Deck,

I'm going to have to take a guess here on what you're describing. Does this
added column have a formula that sums the rows of times??? If so, it may
format itself to show hh:mm, which might look like mm:ss. Try changing the
format (Format - Cells - Number - Custom) to hh:mm:ss.
--
Earl Kiosterud
www.smokeylake.

"deck4" wrote in message
...
I import a text file into Excel. I need to add one column of data that
contains minutes and seconds. I can use the SUM function to add a range
okay, however, when the total is more than one hour it fails to show me
the
hour column and displays a small value in minutes only. I need to be able
to
add the minutes and seconds and come up with a total showing the total
hours
minutes and seconds for a range in this column. I listed the exact format
that I import into Excel below. Thank you in advance.

0:15
3:00
0:30
0:15