total minutes in access 2003

[JWilliams]

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.

[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

[Jeff]

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.

[salad]

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.

[JWilliams]

Thanks for the information. It worked great.