Round up a time to the next 15 minutes
 

Hi all,

I have a column of numbers in [hh]:mm format. Now I want to round up each
time to the next 15 minutes, e.g.

15:43 - 15:45
15:46 - 16:00

The ROUNDUP function does not provide a direct solution for me. Any
suggestion? Thanks a lot.

Frederick Chow
Hong Kong.

Round up a time to the next 15 minutes
 

One way:

=CEILING(A1,1/96)



XL stores times as fractional days, so 15 minutes = 1/96 day.

In article ,
"Frederick Chow" wrote:

Hi all,

I have a column of numbers in [hh]:mm format. Now I want to round up each
time to the next 15 minutes, e.g.

15:43 - 15:45
15:46 - 16:00

The ROUNDUP function does not provide a direct solution for me. Any
suggestion? Thanks a lot.

Frederick Chow
Hong Kong.

Round up a time to the next 15 minutes
 

=ROUNDUP(A2*96;0)/96

--
HTH
--
AP

"Frederick Chow" a écrit dans le message
de ...
Hi all,

I have a column of numbers in [hh]:mm format. Now I want to round up each
time to the next 15 minutes, e.g.

15:43 - 15:45
15:46 - 16:00

The ROUNDUP function does not provide a direct solution for me. Any
suggestion? Thanks a lot.

Frederick Chow
Hong Kong.

Thanks a lot!
 

Oh! Thanks for reminding me the CEILING and FLOOR function can do the
tricks. Thanks for your reminder.

Fredeick Chow
Hong Kong
"JE McGimpsey" wrote in message
...
One way:

=CEILING(A1,1/96)



XL stores times as fractional days, so 15 minutes = 1/96 day.

In article ,
"Frederick Chow" wrote:

Hi all,

I have a column of numbers in [hh]:mm format. Now I want to round up each
time to the next 15 minutes, e.g.

15:43 - 15:45
15:46 - 16:00

The ROUNDUP function does not provide a direct solution for me. Any
suggestion? Thanks a lot.

Frederick Chow
Hong Kong.

Thanks a lot!
 

Thanks very much for your alternative version! Though more obscure, your
version does make sense to me.

Frederick Chow
Hong Kong.

"Ardus Petus" wrote in message
...
=ROUNDUP(A2*96;0)/96

--
HTH
--
AP

"Frederick Chow" a écrit dans le
message
de ...
Hi all,

I have a column of numbers in [hh]:mm format. Now I want to round up each
time to the next 15 minutes, e.g.

15:43 - 15:45
15:46 - 16:00

The ROUNDUP function does not provide a direct solution for me. Any
suggestion? Thanks a lot.

Frederick Chow
Hong Kong.

Round up a time to the next 15 minutes
 

A slight variation to perhaps make the purpose a little more
transparent

=CEILING(A1,"00:15")


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=519089