Thread: How do i convert a number of seconds to a date/time?

I have some system logs that have a number that is either a serial number or
the number of seconds. I have tried to use the Convert function, format the
cell to date/time, but it doesn't look reasonable. I've read that serial
numbers start at 1/1/1900, but this would put my date/time at september 2005,
and we aren't there yet. Any suggestions and ideas would be helpful.

Margo,

Time is stored as a fraction of 1 day, dates as the number of date from
01/01/1900. Today, 9:00PM has a value of 38,356.88.

If your number is in seconds, divide it by 86,400 (24*60*60) to get a
date/time number.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Margo" <Margo@discussions.microsoft.com> wrote in message
news:635DF1E1-289D-4B30-B1FF-F48DC1825570@microsoft.com...
> I have some system logs that have a number that is either a serial number
or
> the number of seconds. I have tried to use the Convert function, format
the
> cell to date/time, but it doesn't look reasonable. I've read that serial
> numbers start at 1/1/1900, but this would put my date/time at september
2005,
> and we aren't there yet. Any suggestions and ideas would be
helpful.88

Do you have an example number and the approximate date/time that it should
represent?

Tim C

"Margo" <Margo@discussions.microsoft.com> wrote in message
news:635DF1E1-289D-4B30-B1FF-F48DC1825570@microsoft.com...
>I have some system logs that have a number that is either a serial number
>or
> the number of seconds. I have tried to use the Convert function, format
> the
> cell to date/time, but it doesn't look reasonable. I've read that serial
> numbers start at 1/1/1900, but this would put my date/time at september
> 2005,
> and we aren't there yet. Any suggestions and ideas would be helpful.