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

Hours
 

I assume that your data looks exactly as you have preseneted it. It is a text
string like "12 h 40"... Assuming that to be the case this formula should
work for you...

=ROUND(VALUE(RIGHT(A1, 2))/15, 0)*15
--
HTH...

Jim Thomlinson


"Paul" wrote:

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

Hours
 

divide by 15.0
then use round function
then multiple by 15

"Paul" wrote:

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

Hours
 

=ROUND(A1*96,0)/96

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Paul" wrote in message
...
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