Time t conversion

baillieston

Board Regular
Joined
Jan 9, 2003
Messages
94
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
 

Excel Facts

Which lookup functions find a value equal or greater than the lookup value?
MATCH uses -1 to find larger value (lookup table must be sorted ZA). XLOOKUP uses 1 to find values greater and does not need to be sorted.
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"
 
Upvote 0

Forum statistics

Threads
1,213,551
Messages
6,114,267
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top