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