Adding up time in decimal value

[awol]

Hi

I'm trying to add up some cells containing the formula =(X1*0.64/60)

The idea is that it rounds up to the nearest decimal point, fo
example...

100 X 0.64 = 64, but I want it to show 1.1 (Like 1 hour and point 1 o
an hour)

This I can do, but the problem comes when adding up the cell
containing the
1.1. For example 15 cells containing 1.1 add up to only 16 but I wan
them to
add up to 16.5.

(15 X 1.1 instead of 15 X 64/60)

Is there anybody out there who can help?

 

[Peo Sjoblom]

=15*ROUND(64/60,1)



--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com

 

[awol]

Hi Peo

Thanks for your reply.

I'm still a little confused, the figures are changable values so I
won't always
have 16.5 as the answer. The formular in the cell at the moment is...

=(F24+F26+F28+F30+F32+F34+F36+F38+F40+F42+F44+F46+F48+F50+F52)

Each of the F cells contains a variable value, in this case 1.1.

Is there a way of adapting this formular to work with the current
formular?