Rounding Time values
*sigh*
--
John C
"John C" wrote:
=ROUND(A1*24,0)/24
This assumes A1 is a time only (no time/date).
Hope this helps.
--
John C
"mebsmith" wrote:
I am looking to round a time field such as this:
6:40:00 AM
to the nearest hour, keeping it in a format so that it can be displayed in
24hr format for easy identification as to the time of day. Even keeping the
AM/PM would be fine too.
Any suggestions? I have exhausted all the ones i thought would work.
Thanks
|