I am constucting a time sheet that is driving me nuts. The following formula calculates the employees total time worked in one day (it works fine). The input cells (time in/out) are time formated. The total hours worked cell (which has the formula below in it) is formated as number w/2 decimal places. I can not come up with the correct formula to convert the decimals to tenths of hours and have it match my companies conversion chart. What do I need to do? Thank you to anyone who can help me.
TOTAL HOURS WORKED:
'=IF((OR(B15="",B14="")),0,IF((B15<B14),((B15-B14)*24)+24,(B15-B14)*24))+IF((OR(C15="",C14="")),0,IF((C15<C14),((C15-C14)*24)+24,(C15-C14)*24))+IF((OR(E15="",E14="")),0,IF((E15<E14),((E15-E14)*24)+24,(E15-E14)*24))+IF((OR(F15="",F14="")),0,IF((F15<F14),((F15-F14)*24)+24,(F15-F14)*24))
HOURS CONVERSION CHART (Sample)
0 min - 2 min, 59 seconds = .0
3 min - 8 min, 59 seconds = .1
9 min - 14 min, 59 seconds = .2
15 min - 20 min, 59 seconds = .3
Bookmarks