Man hour

[Ced]

We have a fairly simple database on the form you must input a start date & time and ending date & time.

For example: start date 03/22/02 time 08:00 AM
ending date 03/23/02 time 5:00 PM

Would yield 18 or 16 hours depending if you count lunch.
We need access to calculate these hours

 

[benwah]

the Datediff function might do the trick.

wah

 

[n2ckb]

Hi there
Give this a go. It allows you to set the core hours.
'Store your core hours start and end times in two variables. Here they are CoreS and CoreF

CoreF = "17:00"
CoreS = "08:00"

CoreHours = DateDiff("h", CoreS, CoreF) - Lunch 'You can add the number of hours allocated to lunch per day

CoreDiff = DateDiff("h", CoreS, Stimestr) + DateDiff("h", Etimestr, CoreF)

'corediff checks to see whether the times entered are out of core hours. If the data is always the same, don't use it

Dresult = DateDiff("d", Sdatestr, Edatestr) + 1

ManHours = (Dresult * CoreHours) - CoreDiff

Let me know whether this is the solution..

N