IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 1 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Software and Applications Forum / If you want a text result...
Post #196,126
by Steven A S
Picture of Steven A S
2/23/05 3:33:19 PM
Reply
New If you want a text result...
from date source you can use something similar to:
=TEXT(A1,"h:mm:ss AM/PM")

This seems to work from a text source as well as long as it's in the format you show.

but the easiest way as has been said, is to format the cells to show just the time
~~~)-Steven----

"I want you to remember that no bastard ever won a war by dying for his country.
He won it by making the other poor dumb bastard die for his country..."

General George S. Patton
Post #196,358
by alvitale
2/25/05 4:27:25 PM
Reply
New Thanks to all who contributed. I didn't respond to the
because the person who sent the data has not yet replied to me.

Thanks again everyone.

Al Vitale
     Excel Question - (alvitale) - (20) - Feb. 22, 2005, 04:24:57 PM EST
         If that's an actual time... - (pwhysall) - Feb. 22, 2005, 04:27:40 PM EST
         Enter in TargetCell: "=Right(SourceCell, 12)" HTH! (HTW :-) -NT - (CRConrad) - (8) - Feb. 22, 2005, 04:28:56 PM EST
             Will only work for string literals - (pwhysall) - (7) - Feb. 22, 2005, 04:29:29 PM EST
                 Al's question looks like string literals are what it's about -NT - (CRConrad) - (6) - Feb. 22, 2005, 04:31:13 PM EST
                     Looks like Excel's default rendition of a date/time serial -NT - (pwhysall) - (5) - Feb. 22, 2005, 04:31:42 PM EST
                         Default? On Yank Winders, perhaps, yes... - (CRConrad) - (4) - Feb. 23, 2005, 02:18:14 AM EST
                             Al's Winders will be Yankish, I wot. -NT - (pwhysall) - (3) - Feb. 23, 2005, 03:25:53 AM EST
                                 Quite possib -- hey, quite *probable*, even! -NT - (CRConrad) - (2) - Feb. 23, 2005, 03:50:57 AM EST
                                     And they'll all buffer overflow on 12/31/2024 -NT - (ChrisR) - (1) - Feb. 23, 2005, 09:44:53 AM EST
                                         Why then; izzat when Al's Social Security runs out, or...? -NT - (CRConrad) - Feb. 23, 2005, 09:46:57 AM EST
         Use text->column - (bepatient) - (2) - Feb. 22, 2005, 06:29:15 PM EST
             People! - (pwhysall) - (1) - Feb. 23, 2005, 01:40:12 AM EST
                 Yep, yer probably right. Peculiar, though. I would have... - (CRConrad) - Feb. 23, 2005, 02:24:54 AM EST
         If Peter is right, and that's a numeric date-time value... - (CRConrad) - (4) - Feb. 23, 2005, 02:50:54 AM EST
             Correct - (bepatient) - (3) - Feb. 23, 2005, 07:10:49 AM EST
                 /me falls over - (pwhysall) - (1) - Feb. 23, 2005, 07:12:16 AM EST
                     Settle down fella - (bepatient) - Feb. 23, 2005, 02:37:50 PM EST
                 Well, yes- but maybe he wants the original one *also*. (Al?) - (CRConrad) - Feb. 23, 2005, 09:44:12 AM EST
         If you want a text result... - (Steven A S) - (1) - Feb. 23, 2005, 03:33:19 PM EST
             Thanks to all who contributed. I didn't respond to the - (alvitale) - Feb. 25, 2005, 04:27:25 PM EST

Super-size it!
81 ms