Minutes worked in each hour minus brake in the hour!

Visitor

I’m looking for the best way to calculate hour/minutes worked in each hour of the columns 0_1 1_2 and so on. Minus the minutes from the brakes toke in an hour.

time.PNG

1 Reply

@16itech probably a cleaner way but I think this works.  i changed the headers to be 1, 2, 3 for the 1st, 2nd, 3rd, etc... hour and also used custom number formatting.  see attached

 

=MIN($B2+$C2+P$1/24,$D2+$E2)-MIN($B2+$C2+(P$1-1)/24,$D2+$E2)-MAX(0,MIN($H2+$I2,$D2+$E2,$B2+$C2+P$1/24)-MAX($F2+$G2,$B2+$C2+(P$1-1)/24))