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
.
|