Apple Intelligence now features Image Playground, Genmoji, Writing Tools enhancements, seamless support for ChatGPT, and visual intelligence.

Apple Intelligence has also begun language expansion with localized English support for Australia, Canada, Ireland, New Zealand, South Africa, and the U.K. Learn more >

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.

User profile for user: cporter9
cporter9 Author
User level: Level 1
0 points

Convert date/time to Unix epoch

I have thousands of date time stamps I would like to convert to Unix epoch ten-digit strings. That is, take some thing like:


Dec 9, 2005 10:24 AM


and convert to


1234567890 (only in the correct unix epoch time)


What formula can I use? I've found that this "=DATE(1970,1,1)+P2/86400" can convert a 10 string epoch time down to just a date correctly, but without time. But I need to go in the opposite direction, with the time included.


Using Numbers 09 ver 2.0.5 (368)

Mac OS X (10.6.7)

Posted on Apr 20, 2011 8:04 AM

Reply
Question marked as Top-ranking reply
User profile for user: Jerrold Green1
Jerrold Green1
User level: Level 7
30,241 points

Posted on Apr 20, 2011 10:12 AM

CP,


An up-to-date Unix Time would be provided by:


=DUR2SECONDS((NOW()-"1/1/1970"))


A somewhat more robust form would be:


=DUR2SECONDS(NOW()-DATE(1970,1,1))


If the time to be converted is in Cell P2, the expression would be:


=DUR2SECONDS(P2-DATE(1970,1,1))


Jerry

View in context
1 reply

Convert date/time to Unix epoch

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