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!!!