Secinds from 1980-01-01

[nailers67]

I have a cell that shows a date shown in seconds from 1980-01-01 and i
want to convert this....how could i do this?

thanks
nails

 

[Norman Harker]

Hi nails!

Use:

=DATE(1980,1,1)+A1/(24*60*60)
Format as (eg) dd-mmm-yyyy hh:mm:ss

Or:
="1980-01-01"+A1/(24*60*60)

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)

It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH.
See:
http://www.microsoft.com/security/protect/

 

[Alan]

I have a cell that shows a date shown in seconds from 1980-01-01 and i
want to convert this....how could i do this?

thanks
nails

Assume your date in seconds from 1 Jan 1980 is in A1:

First convert to days:

=((A1/60)/60)/24

Now add that to the starting date:

=((A1/60)/60)/24+VALUE("1 Jan 1980")

That will give you the date / time in standard excel terms.

If you need to be very precise, you might have to investigate whether
1 second has been defined in your system as 1 Jan 1980, 00:00:01 or
exactly midnight.

HTH,

Alan.