calculation hours Question...

[ultra5219]

hi guys
i got question regarding calculation time. is it my table based on screenshot, can able to calculate hours of employee? from start time to end time.
for example: from 08:00:00AM - 9:00:00AM... Total hours: 1 hour

is it query method can do hours calculation?
let me know how to do in query or other method?

Thanks again...
Attachment 11999

[June7]

Use DateDiff function:

DateDiff("h",[end_time],[star_time])

Will any slots cross midnight?

[ultra5219]

Nope.. No slots for midnight.. Only until 4:30pm... Is that method using query?

[June7]

You can use DateDiff in query, textbox, or VBA, maybe even somehow in macro (I don't use macros).