Use this formula. The 10/24 is the offset from UTC. In this case, for Brisbane, Australia which is 10 hrs ahead.
=(((D2/60)/60)/24)+DATE(1970;1;1)+(10/24)
http://spreadsheetpage.com/index.php/tip/converting_unix_timestamps/
http://www.fourmilab.ch/documents/calendar/
All of the interesting technological, artistic or just plain fun subjects I'd investigate if I had an infinite number of lifetimes. In other words, a dumping ground...
Subscribe to:
Post Comments (Atom)
tim's shared items
No comments:
Post a Comment