Hi to all,
Please bear with me as I am newly experienced in basic Access 2003 only. I don't know Visual Basic or macros at all but am attempting to learn on my own.
Explanation:
Our fleet of trucks have been installed with a GPS tracking system that downloads into csv files all detailed information. The drivers also swipe a card for when they start their shift and when they end their shift. I then downloaded this information into Access.
We have grave, day, swing and night shifts. The drivers are paid every 2 weeks which comes out well over 100 hours per pay period. The total shift time downloads as seconds along with start date and time and end date and time. I need a total hours worked to give to payroll.
In a query I divide the seconds by 86400 (total seconds in a day) to get the hours and minutes in short time format ... (ex: 11:58 for one shift).
Is it possible in a report to sum-up all of the hours, which is normally over 100, in a 2-week period and if so, How?
Right now I'm downloading the Access data to Excel where I am able to get total hours over 99 to turn into Payroll.
Please forgive me if I have not sent this to you correctly or have not worded it correcly. I've never done this before and feel well out of my league.
With appreciation,
Joan Bosrock
3 1850 nico5038 3,080
Recognized Expert Specialist
For some background on time calculations you can check: http://www.mvps.org/access/datetime/index.html
Main "problem" for >24 hours will be the fact that Access will convert them into days. Only when you use an integer (or double) numeric value to store the hours per shift (use e.g. the subtraction you see in the above link), you can add them up to values above 24.
Nic;o)
Hi Nic,
Thank you for the response and the link. Even though I'm a true newbie when it comes to this I'll play around with it this week and see if I can make some sense out of it.
Again, thanks for the help!
Joan :-}
nico5038 3,080
Recognized Expert Specialist
Keep me posted :-)
Nic;o)
Sign in to post your reply or Sign up for a free account.
Similar topics |
by: Phil Sandler |
last post by:
All,
I have a table with start and end dates/times in it, and would like to
be able to calculate the number of hours represented, accounting for
overlapping records.
Note that I am looking for an answer on HOW to do this--I don't
necessarily need it to be written for me (although it would not go
unappreciated!).
|
by: Randi |
last post by:
Hi,
Looking for some help with this payrool project I have for class. This is
what the instructor asks for so far. I have it working without errors but
am getting some funky numbers. I am not sure if they would be correct
anyways. Below is the instructions.
and below that is what I have. Any tips or hints would be highly
appreciated.
Regards,
Kelsey
|
by: Mark T. |
last post by:
Hi all,
New to Access......
Trying to create a payroll database for employees
who are paid on the 1st and the 15th of the month.
This is quite different than every 2 week pay periods.
Employees work all hours of the day, any day of the
week, depending on their assignment, and this can change
from day to day. But employees must remain under
40 hours per week. The 1st and 15th pay periods,
|
by: ycg0771 |
last post by:
I'm trying to modify the following program so that it uses a class to store
and retrieve the employee's name, the hourly rate, and the number of
hours worked. Use a constructor to initialize the employee information,
and a method within that class to calculate the weekly pay. It seems that the more I read into this, the more confused I get. Any help will be greatly apreciated.
Here is my latest code...
// Payroll program that...
|
by: John Sitka |
last post by:
Hi,
There are four pay types
standard
shiftpremium
doubletime
doubletimepremium
each hour a person books can be one of these types
| |
by: jbailey006 |
last post by:
I am trying to add the following information to a payroll program I am working on for assignment. Modify the Payroll Program so that it uses a class to store and retrieve the employee's name, the hourly rate, and the number of hours worked. Use a constructor to initialize the employee information, and a method within that class to calculate the weekly pay. Once stop is entered as the employee name, the application should terminate. Her's what I...
|
by: ask84 |
last post by:
PLzzz guyz help me wid this payroll, there's some place where I'm making a mistake and unable to compile this program: WHYYYYY!! I'm so frustrated
It's from Intro to Programming C++ using Dev-C++ (software)
Please help
#include <cstdlib>
#include <iostream>
#include <iomanip>
|
by: hmmtn |
last post by:
I would appreciate any help on this one. Assignment is as
follows: Develop a program that will determine the gross pay for each
of several employees. The company pays "straight time" for the first
40 hours worked by each employee and pays "time-and-a-half" for all
hours worked in excess of 40 hours. You are given a list of the
employees of the company, the number of hours each employee worked
last week and the hourly rate of each employee....
|
by: aureao4 |
last post by:
I'm new to Java and programming. I'm trying to code a payroll program and continue getting errors. The program worked last week, this week I have to add set, get and a class. I've written the class but when I compile the program I get 13 errors. Can anyone assist me with this? Thank you!
Errors I get:
C:\Java>javac *.java
Payroll3.java:18: illegal start of type
while ( !exit )
^
Payroll3.java:18: <identifier>...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |