S
svenne
I'm trying to do a exceldocument where I fill in the time I start, th
time I finish minus how long lunch I had in hours or minutes. I als
need to calculate how much over or undertime I have worked, standar
hour is 8 hours.
here is an example how it could look, its the calculations that
important.
start end lunch totaltime
over/under-time
08.15 17.00 1 h 7 h 45 min -15
07.45 17.15 0.45 min 8 h 45 min +45
please ask if something is unclear.
th
time I finish minus how long lunch I had in hours or minutes. I als
need to calculate how much over or undertime I have worked, standar
hour is 8 hours.
here is an example how it could look, its the calculations that
important.
start end lunch totaltime
over/under-time
08.15 17.00 1 h 7 h 45 min -15
07.45 17.15 0.45 min 8 h 45 min +45
please ask if something is unclear.
th