Minutes worked in each hour minus brake in the hour!

Copper Contributor

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.


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