You can make a difference in the Apple Support Community!

When you sign up with your Apple Account, you can provide valuable feedback to other community members by upvoting helpful replies and User Tips.

Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Formula for converting a unix timestamp to a readable date?

I don't see a formula which will take a unix timestamp integer (i.e the number of seconds since 1/1/1970) and convert that to a readable date. anyone done this before?

Posted on Feb 28, 2008 6:46 AM

Reply
Question marked as Top-ranking reply

Posted on Feb 28, 2008 11:53 AM

Moshe,

On further reflection, you can change the formula I gave you earlier to:

=DATE(1970,1,1)+B2/86400

This eliminates the need for the 1/1/1970 in cell B1 plus combined division.

pw
2 replies
Sort By: 

Formula for converting a unix timestamp to a readable date?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.