Oct 19 2022 02:41 PM - edited Oct 19 2022 02:47 PM
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.
Oct 19 2022 03:39 PM - edited Oct 19 2022 03:40 PM
@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))