Varifying whether 2 imes encompass a time band

Hi,

The data I have available is the duty start and duty end time.

Based on this data alone I want the sheet to return a Yes or No as to whether or not the duty encompasses a specified time band (0200 to 0459).

So were I to enter a start time of 1300 and end time of 2200 I would expect a No

Were I to enter a start time of 2100 and an end time of 0345 I would expect a yes

Were I to enter a start time of 0100 and an end time of 0610 I would expect a yes

Any help would be very gratefully received!

Cheers

Jamie

=if(and('starttime'<=200,'endtime'>=459),"Yes","No")

HTH

Firstly thank you very much, I am less than useless with this.

I have tried the formulae suggested however encountered a couple of issues. Firstly I think an example would make the request clearer;

If I have Row 9 with all the daily report times and row 10 with all of the daily off duty times (some of which will span past midnight) and in row 23 I want to have the afore mentioned Yes or No for each day.

How wouyld I go about that?

Sorry!

Cheers

Jamie

Turns out that;

=IF(PRODUCT({"02:00","04:59"}-A1)<=0,"Yes",IF(PRODUCT({"02:00","04:59"}-B1)<=0,"Yes","No"))

Where the duty start is A1 and the off duty is B1

Does the trick, means nothing to me but a friend passed it on.

Thanks anyway for the help, very much appreciated.

That's not very pretty...

Looks like you've been cross-posting but I have no desire to throw accusations around willy-nilly.

I would recommend finding out how these things work if you ever want to be good at it yourself (and ultimately faster).