Benches Uncategorized

2

Formula for converting a unix timestamp t…

apple Verified

Imported from the Apple Support Forums via the Wayback Machine 🔗

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?

2 replies

Sign in or join Beachball Help to reply.

  1. 0

    pw1840

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    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. 0

    pw1840

    Imported from the Apple Support Forums via the Wayback Machine 🔗

    Moshe,

    From your description of the unix timestamp, it seems that you just need to add the number of days represented by that number to Jan 1, 1970. Thus the formula as used in the demonstration below:

    =B1+B2/24/60/60

    pw

    User uploaded file