time splitting into shifts - Microsoft Community I have to split up time periods into 3 shifts: 14:00-22:00, 22:00-06:00, 06:00-14:00 I'Ve created formulae which work if finish day is not later than start day +1, but I have to extend these formulae to handle more days