View Single Post
  #2   Report Post  
Jason Morin
 
Posts: n/a
Default

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
.