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

 

[steve the fish]

Still not sure i get it but if your original formula does what you want except for times after midnight then maybe try:

=IF(AND(F$53>=$B54,F$53<$C54+($B54>$C54)),$E54,"")

 

[neilmark]

Hi Steve

Doesn't seem to work for the times after midnight