To round to the nearest hour:

=MROUND(A1,1/24)

MROUND requires the Analysis ToolPak add-in be installed in Excel versions
prior to Excel 2007.

--
Biff
Microsoft Excel MVP


"RD" wrote in message
...
I have the following data: 7:45:00 AM I would like to round off to 8:00 (in
24 hour format). I thought it would be simple but I can't seem to get it.