Hello,
I am obviously new here at the forums. I just want to ask if there is any way to determine if a time is between a given time range. I have searched for solutions but has never helped me yet.
e.g.
Start Time: 22:00:00
End Time: 7:00:00
Given Time: 3:43:00
Thanks in advance!
How about:
=IF((E14>D16)*(E14<E16);"Yes";"No")
And use the CSE "Ctrl+Shift+Enter" on this formula.
John.
"I excel at jumping to conclusions"
A non-array formula solution would be:
where A3 is your given time, A1 is your start time, A2 is your end time.
Please Login or Register to view this content.
If someone helped achieve your solution, consider clicking "* Add Reputation" on their post.
If your question has been answered, mark the thread as [SOLVED] using the Thread Tools menu at the top of the thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks