Development Excerpts for the intellectually curious

Converting iPhone Timestamp to Local Time


Convert the Cell Reference to Hours then add the Date Time difference from1/1/2001.  The final step is to adjust the timezone difference from Greenwich mean time to Local time.


Converting UNIX Timestamps to Excel Local Times


=C2/ 86400 + 25569 - 5/ 24