Excel 2013 Quick Tip: Convert Unix (Epoch) time in Excel

Excel 2013 Quick Tip: Convert Unix or Epoch to a human readable time in Excel. Demo on converting epoch time to human readable format.

[casperinmd]

So many other sites forget to tell you to format the field :P

You're a life saver.

[Zetabee]

So great!! I liked the breakdown of the formulas too, so that we can use that to adjust for day light savings time.

[pamelarobinson]

Very helpful! Thank you for posting this!

[karthimalai]

Thanks for the detailed video, Especially on calculating the timezone. I am done with report successfully

[redwireless]

This helped me a great deal; thank you! j

[sts]

Thanks for this video. However, because I have cells like this 1.60943E+12 when I use the formula I end up with Is that because that is a fx? Not sure how to fix this.

[sachinponia]

How do you automatically handle the switch between summer and winter time? Seems like the results would be an hour off for EST if you are looking at your results in Winter time?

[antigoneheart]

Hi, this is a great video but I only received (number signs) instead of the mm/dd/yyyy time P.M. display.

In addition, my epoch time has thirteen digits and not ten digits.

[fan]

How can we show the milliseconds of the time?

[shyamsundar]

Hi am from India. So what should i add instead of ? Can someone help me out.

[FahadKhan-mjdi]

IN MY EXCEL DATE WITH TIME IS NOT COMING