Sum of Round up

**Swordfish** · 08-03-2009, 02:59 AM

I have tried to get the sum of multiple cell in decimal format. but unfortunately it was computed as 100s for example in B2 is 1.30 in B3 is 1.15 and in B4 is 1.15
and the sum is 3.60. Is it posible to round up to 4 instead of 3.60?

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

If you always want to round up either:

=ROUNDUP(SUM(B2:B4),0)

or

=CEILING(SUM(B2:B4),1)

if you wish to Round to nearest Whole Number

=ROUND(SUM(B2:B4),0)

**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"),".",":"))