Time Code - how can I get delta hours using Access?

[solorx7]

I'm trying to calculate work hours between 2 different time stamps. I need it to calculate the total time elapsed, based on an 8 hour shift per day. For Example:

Monday at 8:00 am to Wednesday at 8:00 am would be 16 hours.

I've got a table that converts calendar days to work days, but I can't get the difference calculation to recognize the number of days. For the example above I keep getting 0 hours. It's like the time calculation is stuck on a 24 hour cycle without recognizing the number of days.

I can make this calculation work in excel with the following formula:
(Work Days) + (2nd time stamp) - (1st time stamp), or for the example above (2) + (8:00:00) - (8:00:00) = 16 hrs. Work days is a whole integer, and the time stamps are hh:mm:ss It also gets screwed up in excel when the 2nd time stamp happens to be earlier in the day than the 1st time stamp.

There's got to be a way to make this work in Access. I'm stumped.

Thanks in advance

 

[blueshark]

Use DateDiff

DateDiff("d",[date1],[date2])

 

[blueshark]

Oops I meant

DateDiff("h",[date1],[date2])

but I'm sure you would have figured that out

 

[CT Witter]

Unfortunately, Blue Shark's code will give you TOTAL elapsed time, not working time, which I believe is what you require.

Take a look at my post at http://www.mrexcel.com/board2/viewtopic.php?t=85533&highlight=

HTH,
CT

 

[solorx7]

Thanks - I'll give it a try.