Okay, I've been looking everywhere to figure this out. I have a schedule all put together that currently calculates the total hours per person for the day and for the week. I now need to calculate the total number of hours in each shift separately. Shift 1 is before 4:00pm, and Shift 2 is after 4:00pm. No need to include lunch breaks since they don't have to clock off for breaks.
For example:
Evan worked from 6:00am to 4:00pm, so his hours should be included in Shift 1.
Sue worked from 4:00pm to 10:00pm, so her hours should be included in Shift 2.
And to make things even more complicated:
Scott worked from 11:00am to 8:00pm, so his hours should be divided into both shifts (11am to 4pm in Shift 1, and 4pm to 10pm in Shift 2).
I would then total the number of Shift 1 hours in one cell, and Shift 2 hours in a separate cell.
Thanks for your help!!!
Bookmarks