formula trouble

[Guest]

I am having a problem with my spreadsheet.

K5 =SUM(C5:J5)
L5 =INT(K5)+HOUR(MOD(K5,1)/14.4)+(MINUTE(MOD
(K5,1)/14.4)/100)

example: E5=.30 F5=.30 I5=.15 J5=.30
i need K5 to equal 1.45

im getting k5= 1.05

 

[Frank Kabel]

Hi
the problem is that you sum the 'time values' first and then make the
conversion. Sou you have to use your second formula on EACH of the
values first before summing then

BUT why don't you use Excel's time format and enter the values like
0:30
0:15
....

and simply sum these values

 

[Guest]

thank you for your help with the formula below. that seems
to be
working great, but sometimes in E5:j6 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))