I'm trying to analyse a list of times.
Column A has start times, Column B has end times. Column D,E,F,G,H,I are columns that calculate how much time has been lost each hour.
E.g. A2 = 07:15 B2 = 07.45 D2 = 30:00
I'm having problems figuring out a formula to calculate times in Column B that overlap the times set for Column D,E,F,G,H,I.
E.g. A3 = 07:55 B3 = 08.20
D3 should = 05:00 and E3 should = 20:00
Can you help?
Solved by A. A. in 24 mins