Thank you all for your help. What seems to be the problem is the original
format was different for each row (Ex. 37:10:46:54, 23:11, 6:26:54) So I
formatted a column as text and using vba copied the text of each cell into
the text formatted column so that they all were uniform in format (I added
0's and colons as needed) then changed the format to [h]:mm:ss.00. However,
the numbers values show as text and not as numbers or elasped time. This
data was parsed from a spreadsheet derived from html. So when the elapsed
time includes milliseconds it shows as text. I need a formula to convert
the text to a number that would represent the elasped time including
milliseconds.

"Satti Charvak" wrote:

You can use the below formula to calculate into seconds and do the sum total
and finally convert the data to hours, minutes and seconds

=HOUR(A1)*3600+MINUTE(A1)*60+SECOND(A1)


--
Kind Regards,
Satti Charvak
Only an Excel Enthusiast
Noida, India


"Kaykayme" wrote:

I have 392 rows of accumulated hours to calculate. I have tried using the
sum function but it only gives 0. However, when I add individual cells I get
a total but it is not correct.
Example:
A1 = 37:10:46.54 and A2 = 23:11:00.00
Formated: [h]:mm:ss.00
Formula: =A1+A2.
I tried using a different time format [h]:mm:ss but I still get 0.

Is there a limit on rows to calculate?