Yes, you are right it would be 7pm. Shifts could run from 0, up to 8 hours. (usually lines run 2hrs, 4hrs, or 8hrs)

When I did it in my head I was thinking start time at 6:30am and added the hours from there. 6:30 is just when I update the schedule.


I won't be accounting for breaks or for lunch. The average time for parts to come off the line will be figured as an average for the whole shift.

I will make the corrections to the spread sheet now. (I re-uploaded the spread sheet as Account for shifts 2)