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

 

[Fluff]

Duplicate https://www.mrexcel.com/forum/excel-questions/1083896-time-function-help-formula-needed.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).