Re: Adding mm:ss values
- From: "JoeU2004" <joeu2004@xxxxxxxxxxx>
- Date: Mon, 1 Jun 2009 09:39:26 -0700
"Howard Kaikow" <kaikow@xxxxxxxxxxxxx> 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" <kaikow@xxxxxxxxxxxxx> wrote in message news:%23HsmdRt4JHA.4932@xxxxxxxxxxxxxxxxxxxxxxx
"JoeU2004" <joeu2004@xxxxxxxxxxx> wrote in message
news:OAqViLt4JHA.3304@xxxxxxxxxxxxxxxxxxxxxxx
"Howard Kaikow" <kaikow@xxxxxxxxxxxxx> wrote:results
> 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
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.
.
- Follow-Ups:
- Re: Adding mm:ss values
- From: Howard Kaikow
- Re: Adding mm:ss values
- References:
- Adding mm:ss values
- From: Howard Kaikow
- RE: Adding mm:ss values
- From: Sean Timmons
- Re: Adding mm:ss values
- From: David Biddulph
- Re: Adding mm:ss values
- From: Howard Kaikow
- Re: Adding mm:ss values
- From: JoeU2004
- Re: Adding mm:ss values
- From: Howard Kaikow
- Adding mm:ss values
- Prev by Date: RE: Eliminate #N/A in Vlookup formulas
- Next by Date: Dates and IF Functions
- Previous by thread: Re: Adding mm:ss values
- Next by thread: Re: Adding mm:ss values
- Index(es):
Relevant Pages
|
