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

Welcome to IWETHEY!

New Looks like Excel's default rendition of a date/time serial


Peter
[link|http://www.ubuntulinux.org|Ubuntu Linux]
[link|http://www.kuro5hin.org|There is no K5 Cabal]
[link|http://guildenstern.dyndns.org|Home]
Use P2P for legitimate purposes!
New Default? On Yank Winders, perhaps, yes...
...but not on mine (and not on yours, I'd have thought), where the default *Windows* date and time formats -- which Excel obeys, AFAIK -- are different.

I mean, as long as you want to be *quite* exact about these things... (And people call *me* "anal"?!?)


   [link|mailto:MyUserId@MyISP.CountryCode|Christian R. Conrad]
(I live in Finland, and my e-mail in-box is at the Saunalahti company.)
Your lies are of Microsoftian Scale and boring to boot. Your 'depression' may be the closest you ever come to recognizing truth: you have no 'inferiority complex', you are inferior - and something inside you recognizes this. - [link|http://z.iwethey.org/forums/render/content/show?contentid=71575|Ashton Brown]
New Al's Winders will be Yankish, I wot.


Peter
[link|http://www.ubuntulinux.org|Ubuntu Linux]
[link|http://www.kuro5hin.org|There is no K5 Cabal]
[link|http://guildenstern.dyndns.org|Home]
Use P2P for legitimate purposes!
New Quite possib -- hey, quite *probable*, even!
;-)
New And they'll all buffer overflow on 12/31/2024
New Why then; izzat when Al's Social Security runs out, or...?
     Excel Question - (alvitale) - (20)
         If that's an actual time... - (pwhysall)
         Enter in TargetCell: "=Right(SourceCell, 12)" HTH! (HTW :-) -NT - (CRConrad) - (8)
             Will only work for string literals - (pwhysall) - (7)
                 Al's question looks like string literals are what it's about -NT - (CRConrad) - (6)
                     Looks like Excel's default rendition of a date/time serial -NT - (pwhysall) - (5)
                         Default? On Yank Winders, perhaps, yes... - (CRConrad) - (4)
                             Al's Winders will be Yankish, I wot. -NT - (pwhysall) - (3)
                                 Quite possib -- hey, quite *probable*, even! -NT - (CRConrad) - (2)
                                     And they'll all buffer overflow on 12/31/2024 -NT - (ChrisR) - (1)
                                         Why then; izzat when Al's Social Security runs out, or...? -NT - (CRConrad)
         Use text->column - (bepatient) - (2)
             People! - (pwhysall) - (1)
                 Yep, yer probably right. Peculiar, though. I would have... - (CRConrad)
         If Peter is right, and that's a numeric date-time value... - (CRConrad) - (4)
             Correct - (bepatient) - (3)
                 /me falls over - (pwhysall) - (1)
                     Settle down fella - (bepatient)
                 Well, yes- but maybe he wants the original one *also*. (Al?) - (CRConrad)
         If you want a text result... - (Steven A S) - (1)
             Thanks to all who contributed. I didn't respond to the - (alvitale)

China...
113 ms