By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,224 Members | 1,523 Online
Bytes IT Community
+ 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
Share this Question
Share on Google+
4 Replies


P: n/a
Br
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" <jw*******@bfair.org> 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.