Adding Hours worked
I had the same problem and this is the way I did it:
(Time out before Lunch - Time in befor lunch)*24 + (time out after lunch -
time in after lunch)*24
This will give you a total in decimal for the whole day
Hope I was helpfull
Regards
"randeerae" wrote:
I need to set up a calculated sheet that will add the before lunch hours with
the after lunch hours, then divide by the 24 hour clock
|