By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,533 Members | 2,102 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,533 IT Pros & Developers. It's quick & easy.

Calculating Times for Payroll over 99 Hours

P: 2
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
Mar 23 '07 #1
Share this Question
Share on Google+
3 Replies


nico5038
Expert 2.5K+
P: 3,072
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)
Mar 24 '07 #2

P: 2
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 :-}
Mar 26 '07 #3

nico5038
Expert 2.5K+
P: 3,072
Keep me posted :-)

Nic;o)
Mar 27 '07 #4

Post your reply

Sign in to post your reply or Sign up for a free account.