I have a roster.
And I currently use a formula that takes a half hour break out of the worked hours, but also inputs the data as blank if S/L, A/L,STAT or -. is entered into the shift boxes.
What would be fantastic is if it only calculated the hour hour break if the shift is more than 5 hrs long, and calculates an hour break if the shift is more than 10hrs long.
So if the shift is only 4hrs long then there would be no break subtracted.
I shall attach an example workbook.
If theres any feedback on making the formulas simpler or if i missed an easy way to do this please let me know.roster snapshot.pngroster snapshot.png
Bookmarks