Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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!!!!! |
#2
|
|||
|
|||
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!!!!! |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
Simplify formula | Excel Worksheet Functions | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |