Hello Glenn,

No, there are no examples in the data of that scenario.

Custhasno wanted a formula that will return zero in a scenario like row 19 where request time/date is 6 minutes after Allocated time/date, so if that 6 minutes occurred across midnight (which I assume may be possible) then shouldn't the answer still be zero, e.g. if the request time/date in row 55 is 10 minutes later, i.e. 22/10/2017 at 00:05, but Allocated time remains at 21/10/2017 at 23:59?

That's another instance of the request time being after the allocated time, but your formula gives 23:54