Simple worksheet where:
Cell E6 is time in as in 7:28 AM cell formatted as h:mm
Cell F6 is time out as in 4:32 PM and the cell is also formatted as h:mm
Cell G6 is total using formula
That works fine giving 9:04
My Problem is when I try to add say five days of the results in column G, nothing I have tried gives correct total.
Is there a specific way to calculate these Hour:Min results?
BTW I have also tried formatting cell E and F as Time 1:30 and 13:30. Both work for the daily result. But the 5 day total still does not
Thanks in advance.
Cell E6 is time in as in 7:28 AM cell formatted as h:mm
Cell F6 is time out as in 4:32 PM and the cell is also formatted as h:mm
Cell G6 is total using formula
=IF(F6<E6,F6+1,F6)-E6 |
My Problem is when I try to add say five days of the results in column G, nothing I have tried gives correct total.
Is there a specific way to calculate these Hour:Min results?
BTW I have also tried formatting cell E and F as Time 1:30 and 13:30. Both work for the daily result. But the 5 day total still does not
Thanks in advance.
9:05 |