"Howard Kaikow" wrote:
The downloaded file was a tab delimited text file.
I gave the file a .xls etension and then opened wit Excel.

Geesh, I did not even know that worked until I tried it.

I assume that the times in the tab-delimited text file are in the form
mm:ss, not 0:mm:ss. Unfortunately, you neglected (once again) to mention
that.

In that case, if you select one of the "min:sec" cells and click on Format
Cells Number, you will see that the cell is formatted as hh:mm. So it is
being interpreted as hr:min, not min:sec.

If you implemented Sean's suggestion (especially the part about formatting
the results as hh:mm:ss), you should have gotten numbers that looked almost
right, but with ":00" as a suffix. (You might have told us that.)
Ironically, if you had not formatted the result explicitly, it should have
looked like what you expected, unless the "minutes" (really hours) exceeds
24.

(But it is not good to leave it in that form anyway. The misinterpretation
as hr:min will bite you sooner or later.)

The question of how to proceed depends on your circumstances. One idea:
edit the tab-delimited file and change times from mm:ss to 0:mm:ss. Note:
that assumes that "mm" is 59 or less.

Of course, all of this is predicated on my assumptions in the absence of
concrete information. If my assumptions are wrong, so is my advice. GIGO.


I have posted an example (twice),but,so far, neither
has shown up in the news reader.

It appears that you are using Outlook Express as your news reader and
posting directly to the MS news server.

If that is the case, you might have encountered transient network errors.
Happens to me on rare occassion. Very confusing, since the OE error is
sometimes delayed.

I am assuming that you are not encountering normal posting delays because
this (your third?) posting showed up, but not the others after quite a long
time now.

How are you trying to post examples? You should be able to write them in
text form in the body of your posting just as easily as you write any other
text.


----- original message -----

"Howard Kaikow" wrote in message
...
"JoeU2004" wrote in message
...
"Howard Kaikow" wrote:
I tried both, neither did the deed.

If you want help, it would be useful if you provided some helpful
information. For example, a concrete example and, in this case, the
results
after you "tried both [and] neither did the deed".

I have posted an example (twice),but,so far, neither has shown up in the
news reader.


First, I wonder if the cells that you downloaded are formatted as Text.

The downloaded file was a tab delimited text file.
I gave the file a .xls etension and then opened wit Excel.