MikeMaloney

Development Excerpts for the intellectually curious

Converting iPhone Timestamp to Local Time

=(((CELL_REFERENCE_HERE/60)/60)/24)+DATE(2001,1,1)+(-5/24)

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

 

 

Add comment

biuquote
  • Comment
  • Preview
Loading