Round up a time to the next 15 minutes

[Frederick Chow]

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.

 

[JE McGimpsey]

One way:

=CEILING(A1,1/96)



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

 

[Ardus Petus]

=ROUNDUP(A2*96;0)/96

 

[Frederick Chow]

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

Fredeick Chow
Hong Kong

One way:

=CEILING(A1,1/96)



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

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.

 

[Frederick Chow]

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

Frederick Chow
Hong Kong.

=ROUNDUP(A2*96;0)/96

--
HTH
--
AP

"Frederick Chow" <[email protected]> a écrit dans le
message
de news:[email protected]...

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.

 

[daddylonglegs]

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

=CEILING(A1,"00:15")