=MROUND(A2,1/24) and format with a time format which suits your
requirements.
Look up MROUND in Excel help.
--
David Biddulph

"mebsmith" wrote in message
...
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