Scenerio:
D24 scheduled start time 3/26 13:15
F24 actual start time 3/26 13:09
I was using =(F24-D24)+IF(F24<D24,1) successfully for this spreadsheet until it came to situations where the actual start time began before the scheduled start time. This statement works well for situations where the time spans across midnight. Is there an additional statement that can be added to the existing statement to address the actual start time beginning before the scheduled start time?
Thank you.