help with formula please

B

Blanca

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
[email protected]
Thanks again!!!!!
 
B

Barb R.

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
 
S

swatsp0p

Try this formula, where B2 is the Time In and C2 is the Time Out:

=((C2-B2)*24)-0.5

B2= 8:00
C2=16:30 (4:30 PM)

formula returns 8

HT
 
Top