“Did a new shift start between Time 1 and Time 2? It sounds like an easy formula, and it probably is, but I sure had a tough time with this formula out. Do you have a solution?” In Episode #1452, MrExcel looks at working with time and day changes.