Sum of time

[#1]

hello all,

i have a numbers like 6.54, 7.36, etc.

each number present time for exemple 6.54 present 6 hours and 54 min.

i nee to sum all this number and the total to show as time.

6.54

   +

7.36

---------

14.30

any suggestion ???

[#2 · Accepted solution]

=Interval(Time(Replace('6.54','.',':'))+Time(Replace('7.34','.',':')))

would do the job.

Kiran.

[#3]

ty very much