adding military time format

[Guest]

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

 

[Jason Morin]

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

 

[Guest]

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