Time t conversion

[baillieston]

Hi,

I have been given a file which has data taken from a UNIX system

There is a column which I am told is a Time t stamp
examples are

1211500536
1211504135
1211507736
1211511332
1211514928

I have been told that these equate to the following dates and times

Fri May 23 00:55:36 2008
Fri May 23 01:55:35 2008
Fri May 23 02:55:36 2008
Fri May 23 03:55:32 2008
Fri May 23 04:55:28 2008

Is there anyway that I can check this with an excel formula or function.
The part that I am most interested in obtaining from the time t stamp is the hour.

I believe the stamp is something to do with the time since 01/01/1970.

Any help would be great.

Thanks

 

[Richard Schollar]

Hi

That's the number of seconds from that date (or from 1am on that date if your date/time values they represent are accurate).

Assume the value is in A1, then you can convert to Excel datetime with:

=A1/86400+"01/01/1970 01:00"

 

[DonkeyOte]

you may need to adjust based on timezone if tz of unix stamp is not the same as the client on which the calculations are being run on ? see...

http://www.mrexcel.com/archive/Dates/30919.html

 

[baillieston]

Thanks all for your response.
This has helped me greatly.

Cheers