If my date and time field is on column A, how do i edit your formula?

"Jarek Kujawa" wrote:

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.