Here’s a simple Excel formula to convert UNIX time to Standard People time, as I like to call it:

=CELL/(60*60*24)+”1/1/1970″

Excel Formula to Calculate Standard Time from UNIX Time

If you then format the new date column in your Excel spreadsheet to TIME with the date and the hour as the parameters, it will show the standard time and date.

This will be handy if you use our Android Data Logging app along with your Sensordrone.  Our logs store data in UNIX time, which is also known as Epoch time.

Leave a Reply

Your email address will not be published. Required fields are marked *

Post Navigation