I have a timesheet and I wish to add an additional function. column A is date, column B is start time of shift and column C is end of shift time. I have a new column (P) which should indicate whether you can start a new shift or not with a "Yes" or "No".
The rule we have to adhere to is as follows: If the end of shift lies anytime after 21:00pm I can not start a new shift for 34 hours from the end of the shift. Normally a shift will end at 03:00am but can be extended for up to 5 hours. Is there a formula I can use?