Thread: Hours
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul Paul is offline
external usenet poster
 
Posts: 661
Default Hours

Newbie question: I have a list of hours (see below) and want to round them
up to the nearest halftime in 15 minutes section. Example: 12h37 would be
rounded to 12h30, 12h46 would be 13h00, 13h05 would be 13h00, 13h17 would be3
13h30 and so on...

How can I easyly do so...please help!

Many thanks.


12 h 40
12 h 37
12 h 37
12 h 34
12 h 31
12 h 27
12 h 27
12 h 26
12 h 24
9 h 46
17 h 14
17 h 11
17 h 11
16 h 14
16 h 06
16 h 06
15 h 16
13 h 00
12 h 55
12 h 24
12 h 16
11 h 10
11 h 10
11 h 07