I have to do a timecard summary, but our production does not clock out for breaks, they just get a half an hour for a full shift (any thing over 6:00).
So in column P I want it to be formatted to read 2:30 for 5 shifts, and 2:00 for 4 shifts, but only if they are 6 hours or more.
Thank you in advance
Bookmarks