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

Stuck on MS Access 2003

P: 1
Hi, i'm a new member of this forum and was wondering if someone could please help me with my problem. I am using a query in access to add up the number of hours that some of my employees are working per week and using the Short time format for the output field which works fine.... until you get to anything over 24 hours, then it starys working it out in days, all i want it to do is produce the total number of hours that each employee works per week in the hh:mm format e.g. 43:30. I would be very grateful if someone could be of assistance, i could send the database if required. Thanks, Nick.

nick.steve@gmail.com
Feb 21 '07 #1
Share this Question
Share on Google+
2 Replies


ronverdonk
Expert 2.5K+
P: 4,258
Welcome to The Scripts!

Since this is an Access question, I will transfer your thread to that forum. You probably you have a better chance to a speedy reply there.

moderator.
Feb 21 '07 #2

Rabbit
Expert Mod 10K+
P: 12,366
I'm thinking you'll have to use DateDiff("n", Beginning Date/Time, Ending Date/Time) to get the amount of minutes. Then you'll have to use int(minutes/60) for the hours and (minutes mod 60) for the minutes.
Feb 21 '07 #3

Post your reply

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