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

Enter current date or time
Ctrl+: enters current time. Ctrl+; enters current date. Use Ctrl+: Ctrl+; Enter for current date & time.

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
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"
 

Watch MrExcel Video

Forum statistics

Threads
1,130,182
Messages
5,640,668
Members
417,160
Latest member
Timon82

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
Top