IF function needed for time intervals

[reggie1000]

hello,

i have a problem with an if function, i need a yes/no if a time is in between different times, unfortunately, the cells are formatted for dd/mm/yyyy hh:mm, if the time is after 10:00 am and before 14:00 pm then yes, if not then no, heres what i have done

Please Login or Register  to view this content.

any ideas????

thanks reg

[arthurbr]

Maybe there is a more elegant solution but try this ( supposing your value is in A1):

Please Login or Register  to view this content.

[reggie1000]

thanks arthurbr,

works great

cheers reg

[arthurbr]

You're welcome and thx for the feedback