what is the time of the day
try sth. like
=IF(HOUR(NOW())<5,"before 5",HOUR(NOW())))
adjust for AM/PM accordingly
On 11 Gru, 16:25, tomas wrote:
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.
|