Formula for time within start/end time and after end time

[cfe4130]

Hi,

I'm using this formula =IF(AND(E2>C3,E2<D3),"Yes","No")

to show when a certain time falls within a start and end time. However, I also need it to display Yes when the time is after E2. Can anyone help with this? Thanks


Date Time In Date Time Out Travel Time End
07/11/2019 09:03 07/11/2019 22:03 07/12/2019 02:03 Yes
07/11/2019 17:50 07/12/2019 06:15 07/12/2019 10:15 Yes
07/12/2019 09:00 07/12/2019 13:30 07/12/2019 17:30 No

[protonLeah]

(How to) Upload a Workbook directly to the Forum
(please do not post pictures or links to worksheets)

• Click Advanced next to "Post Quick Reply" button at the bottom right of the editor box.
• Scroll down until you see "Manage Attachments",
• Click the "Choose" button at the upper left (upload from your computer).
• Select your file, click "open", click "upload"
• Once the upload is completed the file name will appear below the input boxes in this window.
• Close the Attachment Manager window.
• Click "Submit Reply"

Note: Please do not attach password protected workbooks/worksheets
Ensure to disable any Workbook Open/Autorun macros before attaching!

[cfe4130]

Thank you!

[FlameRetired]

Hello cfe4130. Welcome to the forum.

How about

Please Login or Register  to view this content.

These all return "Yes".

[cfe4130]

Thanks, but I need to also show Yes if the travel end time falls between time in and out or if it falls after the time end. It can say No if it falls before the Time In

[FlameRetired]

Which is what my formula does. Please see the amended times in the attached (high lighted yellow) and the formula also applied.

[cfe4130]

I can't figure out why F4 yields Yes, because the travel time end is before the start time of C5. With the old formula, it would yield No which is what I want it to say.

[FlameRetired]

My bad! Apologies. Formula wasn't pointing to the correct row. Please try this instead.

Please Login or Register  to view this content.