Hello All Im trying to find a way to calculate time overlaps.
ex;
If Agent Actual shift is 06:30-15:00 and agents wants to pickup another shift from14:00-22:30 excel calculates 1 hour over lap vise visa
or
If Agent Actual shift is 14:00-22:30 and agents wants to pickup another shift from 06:30-15:00 excel calculates 1 hour over lap
I can have start and end times of shift in one cell or I can also split the start and end times to 2 separate cells whichever would be easiest to calculate time overlap. I would like a non-array formula or VBA any suggestions is greatly appreciated. Let me know if I need to clarify anything.
ex;
If Agent Actual shift is 06:30-15:00 and agents wants to pickup another shift from14:00-22:30 excel calculates 1 hour over lap vise visa
or
If Agent Actual shift is 14:00-22:30 and agents wants to pickup another shift from 06:30-15:00 excel calculates 1 hour over lap
I can have start and end times of shift in one cell or I can also split the start and end times to 2 separate cells whichever would be easiest to calculate time overlap. I would like a non-array formula or VBA any suggestions is greatly appreciated. Let me know if I need to clarify anything.