Here is the formula to convert epoch or unix time to human readable format.
when the data is in A1,
The +8/24 is for the timezone correction as epoch time is in GMT.
Keywords: epoch unix time excel spread sheet conversion
Mind & Media © 2018. All rights reserved.