adding time hh.mm.ss format. I cannot get a sum - only 0

Excel does not recognize hh.mm.ss as time format, hh:mm:ss or use

=SUM(--SUBSTITUTE(A1:A50,".",":"))

entered with ctrl + shift & enter

use custom format [hh]:mm:ss

Regards,

Peo Sjoblom



"am6160" wrote:

adding time hh.mm.ss format. I cannot get a sum - only 0

Excel probably does not recognize your values as true
time values - just text strings. Try summing them with:

=SUMPRODUCT(--SUBSTITUTE(A1:A10,".",":"))

and custom format the formula cell as hh.mm.ss .

HTH
Jason
Atlanta, GA

-----Original Message-----
adding time hh.mm.ss format. I cannot get a sum - only 0
.