working hours between two dates

  • Thread starter Thread starter DubboPete
  • Start date Start date
D

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
 
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
 
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 -
Click to expand...

Thanks Tom, I shall give it a go!

Pete
 
Back
Top