Round up a time to the next 15 minutes

  • Thread starter Thread starter Frederick Chow
  • Start date Start date
F

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.
 
One way:

=CEILING(A1,1/96)



XL stores times as fractional days, so 15 minutes = 1/96 day.
 
Oh! Thanks for reminding me the CEILING and FLOOR function can do the
tricks. Thanks for your reminder.

Fredeick Chow
Hong Kong
JE McGimpsey said:
One way:

=CEILING(A1,1/96)



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

Frederick Chow said:
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.
Click to expand...
Click to expand...
 
Thanks very much for your alternative version! Though more obscure, your
version does make sense to me.

Frederick Chow
Hong Kong.

Ardus Petus said:
=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.
Click to expand...
Click to expand...
 
A slight variation to perhaps make the purpose a little more
transparent

=CEILING(A1,"00:15")
 
Back
Top