I need a formula that will tell me the time of the day. i have a field with
the date and time (mm/dd/yy hh:mm PM). I need the formula to return the hour
of the day if the hour is after 5PM. For example, if it is 11/29/08 5:23 PM
i want it to return "5". If it is 11/27/08 6:46 PM, i want it to return "6".
For anything before 5PM, i want it to return "before 5".
Thanks.