Let's say you have start time in column A, end time in column B and the lunch
break time in column C (just in case the lunch times change by employee)

A2= 8:00
B2 = 16:30
C2 = 0.5
D2 = (B2-A2)*24-C2 Format column D as number

"Blanca" wrote:

WHAT FORMULA CAN I USE TO CALCULATE TOTAL TIME WORKED MINUS LUNCH for
multiple employees in one time sheet on a weekly basis?
(e.g. in 8:00 am out 4:30 pm minus .5hr lunch)
I have been triying to use the template with break but it does not deduct
the luch time/break time from the total amount of hours actually worked..I
would appreciate any help. if you want to contact me you can do so at

Thanks again!!!!!