adding time hh.mm.ss format. I cannot get a sum - only 0
J Jason Morin Dec 28, 2004 #2 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
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
P Peo Sjoblom Dec 28, 2004 #3 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
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
