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 |