View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Frederick Chow
 
Posts: n/a
Default 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.