Rounding off time

[RD]

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.

 

[Eduardo]

Hi,
try

=ROUNDUP(A1*15,0)/15

 

[Bernard Liengme]

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

 

[RD]

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.

 

[T. Valko]

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.

 

[Shane Devenshire]

Hi,

You can also use

=ROUND(A1*24,)/24

and format to time