time card formulars

[Guest]

formular to use in expression in query to work out hours worked using start
time & finish time

EXAMPLE (start 07:30 - finish 16:00 = 8.5 hours) -
lunch(30minutes)=(8hours worked)

 

[John Spencer (MVP)]

IF your times are both on the same date or also have the date, you can use the
DateDiff function to get the difference in minutes.

DateDiff("n",[Start],[End]) - 30

You can do some math on that figure to get the time in hours and minutes

X\60 & ":" & Format(X Mod 60, "00")

Substitute the DateDiff Function for the X

(DateDiff("n",[Start],[End]) - 30)\60 & ":" &
Format((DateDiff("n",[Start],[End]) - 30) Mod 60, "00")