Time Function help with formula needed

[neilmark]

I need help with a formula
in Row 53 column F I have time at 0:30
In Row 57 column B I have time at 23:10
in Row 57 column E I have result which is comp3

the formula I am using works for all times from 01:00 to 23:00 but post midnight it doesn't work this is what I am using in cell 57 (F) =IFERROR(IF(AND(F$53>=$B57,F$53<$C57),$E57," ")," ") 0:30 should show as greater than 23:10 because its the next day any help would be appreciated


cant seem to get this to work for post midnight times when it should be adding a day tomake the time greater than previous day time

 

[sergioMabres]

Hi Neil,
You could try using

For row 53 the difference can be calculated with
=IF(B53>F53,F53+1-B53,F53-B53)

To avoid negative times and erros
Cheers
Sergio