Finding out if order time is beyond or within the shift using excel formula

[itsdyesss]

Is there any formula that can read a graveyard shift? I already made a formula but it only works for day shift. Please see the attached file. Thank you in advance.

[WideBoyDixon]

Perhaps F3 formula:

=IF(AND(IF($E3<$C3,$E3+1,$E3)>=$C3,IF($E3<$C3,$E3+1,$E3)<=IF($D3<$C3,$D3+1,$D3)),"ordered w/in shift","ordered beyond shift")

Also correct your times that are showing "am".

WBD

[HansDouwe]

Or try

=IF((D3>E3)*(E3>C3)+(C3>D3)*(D3>E3)+(E3>C3)*(C3>D3),"ordered w/in shift","ordered beyond shift")

[kvsrinivasamurthy]

IN G3 copy down.

=IF(MEDIAN(C3,D3,E3)=E3,"ordered w/in shift","ordered beyond shift")