454,224 Members | 1,523 Online
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,224 IT Pros & Developers. It's quick & easy.

# total minutes in access 2003

 P: n/a I am trying to calculate the total minutes in a day that an employee provides services. When an employee works starts at 11 am in the morning and finishes at 12 am (midnight) it is calculating it as 12am start and 11 am finish with a total of 11 hours not the 13 it really is. I also need to print reports for total minutes for each individual served and total for the fiscal year. Feb 21 '06 #1
4 Replies

 P: n/a JWilliams wrote: I am trying to calculate the total minutes in a day that an employee provides services. When an employee works starts at 11 am in the morning and finishes at 12 am (midnight) it is calculating it as 12am start and 11 am finish with a total of 11 hours not the 13 it really is. I also need to print reports for total minutes for each individual served and total for the fiscal year. Off the top of my head... =DateDiff("nn", StartDateTime, EndDateTime) ? -- regards, Br@dley Feb 21 '06 #2

 P: n/a Assuming you are using the DateDiff function, you need to include the date part of the time as well. In other words, don't pass the function just 11 am and 12 am, pass it 02/22/06 11am and 02/23/06 12am. DateDiff("n", "02/22/06 11am", "02/23/06 12am") Jeff Pritchard ________________ Asken Research Pty. Ltd. Access Database Developers http://www.asken.com.au "JWilliams" wrote in message news:11*********************@z14g2000cwz.googlegro ups.com...I am trying to calculate the total minutes in a day that an employee provides services. When an employee works starts at 11 am in the morning and finishes at 12 am (midnight) it is calculating it as 12am start and 11 am finish with a total of 11 hours not the 13 it really is. I also need to print reports for total minutes for each individual served and total for the fiscal year. Feb 21 '06 #3

 P: n/a JWilliams wrote: I am trying to calculate the total minutes in a day that an employee provides services. When an employee works starts at 11 am in the morning and finishes at 12 am (midnight) it is calculating it as 12am start and 11 am finish with a total of 11 hours not the 13 it really is. I also need to print reports for total minutes for each individual served and total for the fiscal year. Does your start/end times include a date? Simply having the time isn't good enough unless you do a comparison whether or not the time out is less than time in. You'll need to make an adjustement if so. Other posters described the DateDiff function if you store both date/time. Feb 21 '06 #4

 P: n/a Thanks for the information. It worked great. Feb 22 '06 #5

### This discussion thread is closed

Replies have been disabled for this discussion.