Sum of Round up

**Swordfish** · 08-03-2009, 03:25 AM

Thanks the formula is ok.

How can I Get the the sum if the there is a 5

example B1 is 1 and B2 is 1.35 B3 is 1 the answer is 4.20 and if I make the B1 for 1.15 and B2 is 1.50 I've got the same answer of 4.20

is it posible to make it 4.05

By the way the formula I'm using is =CEILING(SUM(B2:B4),0.60)

**DonkeyOte** · 08-03-2009, 03:26 AM

I'm afraid I don't understand your requirement, can you post a few examples of totals and the desired outputs ?

**Swordfish** · 08-03-2009, 03:46 AM

Sorry for the confusion,

I'm trying to get the sum of the time in multiple cell. In decimal format

Ex.

B2 is 1 hour 35 minutes
B3 is 1 hour 20 minutes
B4 is 0.hour 15 minutes

sum is 2 hours 70 minutes
It is supposed to be 3 hours and 10 minutes But in decimal format 3.10

I hope it will help.

**DonkeyOte** · 08-03-2009, 03:50 AM

One way where B2: 1.35, B3: 1.20, B4: 0.15

=DOLLARFR(DOLLARDE(SUM(B2:B4),60),60)

EDIT: should add if you wanted 3 hours 10 minutes in time format, given nature of values in B2:B4

=SUMPRODUCT(0+SUBSTITUTE(TEXT(B2:B4,"0.00"),".",":"))