IF function needed for time intervals

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

=IF(AND(A1>="10:00"),"YES",IF(AND(A1<="14:00"),"YES","NO"))

any ideas????

thanks reg

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

=if(and(a1-int(a1)>timevalue("10:00"),a1-int(a1)<timevalue("14:00")),"yes","no")

thanks arthurbr,

works great

cheers reg

You're welcome and thx for the feedback