help with formula please
 

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!!!!!

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!!!!!

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

HTH


--
swatsp0p


------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101
View this thread: http://www.excelforum.com/showthread...hreadid=373891