Hello,
I need to find the hours worked in three shifts: shift1 is from 07:00 to 15:00, shift2 is from 15:00 to 23:00 and shift3 is from 23:00 to 07:00
I can calculate the total hours worked (subtraction of the end time from the start time) but am not able to separate out the hours worked in each shift (1, 2 and 3). Can anyone can help me?
I decided to create an example of my workbook to better explain the result I pretend to have.
Thank you in advanced!
Kind regards,
Bookmarks