You are using a browser which is not compatible with CSS (for more information, see Tara's tutorial). Because of this, it is possible that our website may not appear correctly in your browser. We apologise for the inconvenience, and recommend you upgrade your browser to one which is compatible with CSS. For more information, please visit our Browser Upgrade page.

News:

Search:

Online Tools: Unix Timestamp Converter

Comments
Name: Mel Function	none
It is simpler to use: =([time stamp cell address]/86400)+25569 and then format cell(s) with CUSTOM yyyy/mm/dd hh:mm:ss The "86400" = seconds in a day. The "25569" = number of days from Xcell's 1900 (day one) to unix 1970 (day zero or one?)
Name: Robbie	none
To calculate dates in excel: A1: the timestamp number B1: =integer(A1/86400)+25569 C1: =mod(A1,86400)/86400 Rightclick on B1, choose date format Rightclick on C1, choose time format Voila.
Name: Albert	none
I do like god, but jesus is my kinda guy, hells yea
Name: Bob	none
UTC replaced GMT as the basis for the main reference time scale or civil time in various regions on 1 January 1972. It's a technicality, but also a fair point. Further reading: http://physics.nist.gov/GenInt/Time/world.html
Name: Nick	none
GMT is a timezone that happens to coincide with UTC. It's obviously not outdated as several countries set their clocks to it. However, when referring to unix time UTC probably is the correct term.
Name: Himanshu	none
G8 tool. I use it frequently. Regards, Himanshu
Name: Tarun sharma	tarun dot rgec at gmail dot com
its really good
Name: none	none at nowhere dot com
Not working good
Name: Brian	none
Alex: reference the third paragraph of http://physics.nist.gov/GenInt/Time/world.html.
Name: For Alex	none
It is as much outdated as measuring distance in miles or temperature in Fahrenheit. Catch up with the millennium!
Name: Alex Holsgrove	webmaster at blind-summit dot co dot uk
Laughing at the idiot that said GMT is an "outdated" term.
Name: Goodwine	none
@the one talking about 2038 Well the problem has already arisen at PCs which use times in the future, its called the Y2K38 bug as an allusion to what you mentioned, what may be possible is that they implement integers of 64 bits which will do the work very nicely, it will still have another limit but it will be far after we die xD
Name: Olivier Serre	none
The script is not working with large negative timestamps (as php date())
Name: Brian	none
GMT should probably become UTC instead. GMT is kind of an outdated term...
Name: Beanyhead	none
This helps a lot when debugging applications. Thanks for putting it up.
Name: Lingvik	none
For Chris: Actually the Number is 2147483647 = 2^31 - 1. But the rest remains the same. 64-bit system is the solution.
Name: Me	none
Cool Tool - thx
Name: Dr md - pmai.tk	none
Hi, i am just wondering if u can put the script for that online time stamp converter because it really helps thanks
Name: stpehen	none
great tool:) very handy in that it works for all timezones
Name: Lemeb	none
Great ! Thank you very much !

Add a new comment