Hello,
I have a bit of a problem. I am trying to create a formula that can determine if a date, appearing as DD/MM/YYYY 12:00 PM falls within a certain time frame. Is there a way I could check it to see if falls between a certain time on that date, (example, any time between 5 in the morning and 3 in the afternoon)? I imagine it's probably just checking the hour and minutes within a certain range, but I'm not sure how to do that.
Example
I'd want to see if the times for the below were between 5:00 AM and 4:00 PM (regardless of the date) and if yes, then have a yes result, otherwise no.
20/10/2009 11:03 AM
Any advice would be appreciated. Hope this is clear enough.
Bookmarks