Hi,

You can also use

=ROUND(A1*24,)/24

and format to time


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"RD" wrote:

Thanks for the clue. Wasn't quite it but I changed it to
=ROUND(A1/TIME(0,60,0),0)*TIME(1,0,0) which worked great with a h:mm format.

"Bernard Liengme" wrote in message
...
This rounds the time in A1 to the nearest 15 mins
=ROUND(A1/TIME(0,15,0),0)*TIME(0,15,0)
Of course, you can replace A1 by a formula
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email


"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.