Secinds from 1980-01-01

N

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
 
N

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
[email protected]

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/
 
A

Alan

nailers67 > said:
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
Click to expand...

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.
 
Top