I need to calculate night shift and day shift hours for a 24 hour schedule. Employees can clock in at any time during the day or night and often work more than 12 hour shifts (but not always). Night shift starts at midnight and ends at 8am. I need the formula to account for when the employee clocks in at 7pm and clocks out at 8:30am the following morning (for example), which would be 8 hours of night shift, 5.5 hours of day shift. Please and thank you in advance!!
Bookmarks