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