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.