working hours between two dates

[DubboPete]

Hello all,

Done a search but cannot find an answer. Tryiong to calculate the
working hours between these two dates:

1/13/2010 8:00 AM
1/14/2010 3:00 PM

where working hours are 8am to 5pm

I know the answer should be 16, I can't think of a way of calculating
it over 24,000 entries! Don't worry about lunch, we never get that
hungry here in the salt mines, and we don't pay overtime

thanks in anticipation
Pete

 

[Tom van Stiphout]

On Tue, 2 Mar 2010 18:47:52 -0800 (PST), DubboPete

Sure you can. It's the sum of three numbers: the number of hours in
the first day, the number of hours in the last day, plus the business
days between the first and last.
To calculate the first and second number, check out the DateDiff
function. To calculate the third number, check this out:
http://www.mvps.org/access/datetime/date0006.htm

-Tom.
Microsoft Access MVP

 

[DubboPete]

On Tue, 2 Mar 2010 18:47:52 -0800 (PST), DubboPete


Sure you can. It's the sum of three numbers: the number of hours in
the first day, the number of hours in the last day, plus the business
days between the first and last.
To calculate the first and second number, check out the DateDiff
function. To calculate the third number, check this out:http://www.mvps.org/access/datetime/date0006.htm

-Tom.
Microsoft Access MVP









- Show quoted text -

Thanks Tom, I shall give it a go!

Pete