Convert Unix Epoch Time to Date in Google Sheets

javascript datetime google-apps-script google-sheets epoch
Mike Bjorge picture Mike Bjorge · Jul 21, 2017 · Viewed 68.4k times · Source

I have a sheet with a column of unix epoch times (in seconds): 1500598288

How can I convert these into normal dates?

Answer

ttarchala picture ttarchala · Jul 21, 2017

The simplest way, not requiring any JS programming, would be through a formula, dividing by 86400 seconds per day and adding to January 1, 1970. For example the following gives 21 July 2017:

=1500598288/86400+date(1970,1,1)

To convert a whole column of numbers, just use ARRAYFORMULA:

=arrayformula(A:A/86400+date(1970,1,1))

Related questions

How to properly calculate remaining time in JS using getTime() from the two dates?

I'm trying to calculate remaining time (ex: 10 years, 2 months and 10 days from today(2014/03/02) in JS using this function: var d2 = new Date(2024, 3, 12); var d1 = new Date(); var d0 = new Date(1970, 0, 1); var diff = new Date(d2.getTime() - (d1.getTime() + d0.…

Read More
How do you get a timestamp in JavaScript?

How can I get a timestamp in JavaScript? Something similar to Unix timestamp, that is, a single number that represents the current time and date. Either as a number or a string.

Read More
Compare two dates with JavaScript

Can someone suggest a way to compare the values of two dates greater than, less than, and not in the past using JavaScript? The values will be coming from text boxes.

Read More