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.

Hi,
try

=ROUNDUP(A1*15,0)/15

"RD" wrote:

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.

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.

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.

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.

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.