Help please

when working with decimals the below formula works, but
sometimes in c5:j5 i have whole numbers too like 8.15,
6.30 wich should equal to 14.45 but i am not getting that
with the formula below i got 24.05 i don't understand i
would appreciate your help.

=INT(SUM(E5:J5)/0.6)+(MOD(SUM(E5:J5),0.6))

What do you expect?

" wrote:

when working with decimals the below formula works, but
sometimes in c5:j5 i have whole numbers too like 8.15,
6.30 wich should equal to 14.45 but i am not getting that
with the formula below i got 24.05 i don't understand i
would appreciate your help.

=INT(SUM(E5:J5)/0.6)+(MOD(SUM(E5:J5),0.6))

i would like to be able to calculate E5:j5 to answer in
the following way
10.3 + 10.15 + 10.3 + 5.3 = 36.45 instead of 36.05

-----Original Message-----
What do you expect?

" wrote:

when working with decimals the below formula works,
but
sometimes in c5:j5 i have whole numbers too like 8.15,
6.30 wich should equal to 14.45 but i am not getting
that
with the formula below i got 24.05 i don't understand i
would appreciate your help.

=INT(SUM(E5:J5)/0.6)+(MOD(SUM(E5:J5),0.6))

.

I'm really sorry, but when I add these numbers up I get 36.05 whichever way I do it. I just don't understand what you are trying to do.

" wrote:

i would like to be able to calculate E5:j5 to answer in
the following way
10.3 + 10.15 + 10.3 + 5.3 = 36.45 instead of 36.05

-----Original Message-----
What do you expect?

" wrote:

when working with decimals the below formula works,
but
sometimes in c5:j5 i have whole numbers too like 8.15,
6.30 wich should equal to 14.45 but i am not getting
that
with the formula below i got 24.05 i don't understand i
would appreciate your help.

=INT(SUM(E5:J5)/0.6)+(MOD(SUM(E5:J5),0.6))

.

=INT(SUM(E5:J5)/0.6)+(MOD(SUM(E5:J5),0.6))
..3 + .15 + .3 + .3 = 1.45
this formula enables me to use it for a time calculation.
But it only works when i have decimals no whole number in
the cell. i was wonder what im missing to be able to get
it to work if the decimal that has a whole number with it.



-----Original Message-----
I'm really sorry, but when I add these numbers up I get
36.05 whichever way I do it. I just don't understand what
you are trying to do.

" wrote:

i would like to be able to calculate E5:j5 to answer in
the following way
10.3 + 10.15 + 10.3 + 5.3 = 36.45 instead of 36.05

-----Original Message-----
What do you expect?

" wrote:

when working with decimals the below formula works,
but
sometimes in c5:j5 i have whole numbers too like
8.15,
6.30 wich should equal to 14.45 but i am not
getting
that
with the formula below i got 24.05 i don't
understand i
would appreciate your help.

=INT(SUM(E5:J5)/0.6)+(MOD(SUM(E5:J5),0.6))

.


.

There may be a better way...

=SUM(INT(E5:J5))+INT(SUM(MOD(E5:J5,1)/0.6))+((SUM(MOD(E5:J5,1)/0.6)-INT(SUM(MOD(E5:J5,1)/0.6)))*0.6)

Lance

" wrote:

when working with decimals the below formula works, but
sometimes in c5:j5 i have whole numbers too like 8.15,
6.30 wich should equal to 14.45 but i am not getting that
with the formula below i got 24.05 i don't understand i
would appreciate your help.

=INT(SUM(E5:J5)/0.6)+(MOD(SUM(E5:J5),0.6))

On Wed, 21 Jul 2004 03:28:41 -0700,
wrote:

i would like to be able to calculate E5:j5 to answer in
the following way
10.3 + 10.15 + 10.3 + 5.3 = 36.45 instead of 36.05

The **array** formula:

=INT(SUM(INT(E5:J5)+MOD(E5:J5,1)*100/60))+
MOD(SUM(INT(E5:J5)+MOD(E5:J5,1)*100/60),1)*0.6

To enter an **array** formula, you need to hold down ctrlshift while
hitting enter. XL will place braces {...} around the formula.

If you have the analysis tool pak installed, an alternative **array** formula
is:

=DOLLARFR(SUM(INT(E5:J5)+MOD(E5:J5,1)*100/60),60)


--ron

Thank you

-----Original Message-----
On Wed, 21 Jul 2004 03:28:41 -0700,

wrote:

i would like to be able to calculate E5:j5 to answer in
the following way
10.3 + 10.15 + 10.3 + 5.3 = 36.45 instead of 36.05

The **array** formula:

=INT(SUM(INT(E5:J5)+MOD(E5:J5,1)*100/60))+
MOD(SUM(INT(E5:J5)+MOD(E5:J5,1)*100/60),1)*0.6

To enter an **array** formula, you need to hold down
ctrlshift while
hitting enter. XL will place braces {...} around the
formula.

If you have the analysis tool pak installed, an
alternative **array** formula
is:

=DOLLARFR(SUM(INT(E5:J5)+MOD(E5:J5,1)*100/60),60)


--ron
.