Thread: Rounding Time.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
GEM GEM is offline
external usenet poster
 
Posts: 90
Default Rounding Time.

How can I round time UP to the nearest 5 min. I need to have the report in
numbers divisible by 5 and the time should always go up. 1:30, 1:35, 1:40,
1:45.

For example,

1:41 round it to 1:45
1:43 round it to 1:45
1:46 round it to 1:50
1:48 round it to 1:50
1:40 is kept at 1:40
1:50 is kept at 1:50