- leap seconds aren't counted.
- 23:31:30 UTC on Fri 13 February 2009 was represented by 1234567890 (oooh, spooky)
- get you party hat on Sun 13 September 2020 at 12:26:40 UTC when the clock ticks over to 1600000000 (7/x)
=(A1/86400)+DATE(1970,1,1) to convert UNIX -> Date/Time
=(A1-DATE(1970,1,1))*86400 to convert Date/Time -> UNIX
don't @ me. (8/x)
- HFS+: Seconds since January 1, 1904 12:00:00 AM UTC
- Mac “Absolute Time”: Seconds since January 1, 2001, 12:00:00 AM UTC.
- Chrome/Webkit: Milliseconds since January 1, 1601, 12:00:00 AM UTC.
Ref & thanks: medium.com/@bromiley/tool… (10/x)
- Use ISO 8601 format where possible. Something like: YYYY-MM-DD HH:MM:SS. (I have no words for you MM-DD-YYYY people).
- I've avoided time-zones because really there only is one true timezone: time.is/UTC (14/x)
(now here is a cat with lasers GIF)