Re: Converting from UTC to a "real date" in Excel

[Mike <koldark@xxxxxxxxx>]

Thanks, I didn't see those in the search.

--
Mike Wills
http://mikewills.info
P: (507) 933-0880 | Skype: koldark


On Fri, Nov 6, 2009 at 3:53 PM, David Gibbs <david@xxxxxxxxxxxx> wrote:

> Mike wrote:
> > We are working with a file export with a huge integer for a "date" I am
> > guessing this is using the Unix format for storing dates. Can anyone help
> > with how that date is calculated. I believe it i the number of seconds
> since
> > a given date. Do you know of  way to convert that to an actual date/time
> in
> > Excel?
>
> Check out http://www.mrexcel.com/archive/Dates/30919.html or
> http://excel.tips.net/Pages/T002051_Converting_UNIX_DateTime_Stamps.html
>
> http://tinyurl.com/yl969dp
>
> :)
>
> --
> IBM i on Power Systems - For when you can't afford to be out of business
> --
> This is the PC Technical Discussion for iSeries Users (PcTech) mailing list
> To post a message email: PcTech@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/pctech
> or email: PcTech-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/pctech.