10 digit Unix Timestamp to Date Excel Converter Tutorials

Monday, 25 January 2016 10:34

How to convert a 10 Digit Number (or Unix Timestamp) into a date in excell

Written by Fabien Bello

font size decrease font size increase font size
Print
Email
1408 comments

Rate this item

(4 votes)

How to convert a 10 Digit Number (or Unix Timestamp) into a date in excell

In this article, I reveal step by step instructions to convert a 10 digit number unix timestamp into a date in Excel. This is particularly useful to Joomla users as Joomla stores and exports date as Unix Timestamps.

Unix timestamp is defined as the total number of seconds since midnight (GMT time) on January 1, 1970 - also known as the Unix epoch.

Insert your ten digit unix timestamp in Excel
Timestamp to date formula
GMT offset
Format the cell to date
Format the cell from number to date
Result

Insert your ten digit unix timestamp number in the first cell of your Excel sheet

Type the following formula in the second or third cell of your Exel sheet:

=(((A2/60)/60)/24)+DATE(1970,1,1)

The formula converts the seconds to days and then add them to January 1, 1970

Adjusting the formula for the GMT offset.

If you live in France, you need to adjust to offset by 1 (+1) which gives you the following formula

=(((A2/60)/60)/24)+DATE(1970,1,1)+(1/24)

Right click on the formula cell and click on format cells

In the "number" tab, select Date

10 Digit Unix Timestamp Converted

Read 51264 times Last modified on Tuesday, 26 January 2016 08:30

Published in Microsoft Excel

Tagged under

Fabien Bello

Fabien Bello has been working in web and app develoment since 1997. He has held numerous positions from game developer to head of creative and product development for major firms such as Xerox, Gala Coral Group. Fabien continues contributing to online community, owns and manages several websites as well as offering consultancy to all size businesses.

Latest from Fabien Bello

Related items

More in this category: « How to change a text to lower case and replace space with a dash in Excel

1408 comments

Comment Link Wednesday, 25 May 2022 18:07 posted by Seanagoks
I think, that you are not right. Write to me in PM, we will talk.
are within the publish-combine sizzling wallet, wasabi mix btc You possibly can select to set a minimum variety of mixes you wantin which and how to use mix bitcoin, You can make contact with us at ourmore info relating to wasabi bitcoin mixer download Nicely visit the
Comment Link Wednesday, 25 May 2022 05:39 posted by SlonHausy
ptt5k

h3rth

yhxu
Comment Link Wednesday, 25 May 2022 05:35 posted by SlonHausy
doszp

ofi1r

6xfm
Comment Link Wednesday, 25 May 2022 03:14 posted by SlonHausy
9r0jp

pzqat

ekbu
Comment Link Tuesday, 24 May 2022 19:05 posted by SlonHausy
7h3m9

evptq

wo9d
Comment Link Sunday, 22 May 2022 06:18 posted by Peggyanase
Подтверждаю. Я присоединяюсь ко всему выше сказанному. Можем пообщаться на эту тему. Здесь или в PM.
игровые интернет слоты пин-код ап https://pinupcasino-game.ru/kak-zaregistrirovatsya-v-pin-ap/ - легальный площадку pin up казино.в сети https://pinupcasino-game.ru pin up со ставками смогут ставить только игроки с зарегистрированным аккаунтом.после отправления формы во почту наступит сообщение от https://pinupcasino-game.ru/kak-zaregistrirovatsya-v-pin-ap/ в интернет-адрес с указанием.
Comment Link Wednesday, 18 May 2022 21:32 posted by Chloemug
Да, верно.
then contact 24/7 assist. For your comfort, pin-up casino brasil There is a superb buyer support service. To make use ofutilize pin up fr, You are able to call usrelating to pin up login I implore you to visit the
Comment Link Saturday, 14 May 2022 19:10 posted by is fucking milfs in the ass okay
you are in point of fact a just right webmaster. The site loading pace is incredible.
It kind of feels that you're doing any unique trick. In addition, The
contents are masterwork. you've done a magnificent activity
in this matter!
Comment Link Saturday, 14 May 2022 03:44 posted by 카지노 룰렛 전략
What a data of un-ambiguity and preserveness of precious know-how regarding unexpected feelings.
Comment Link Friday, 13 May 2022 19:15 posted by 파라오 카지노
Every weekend i used to visit this site, for the reason that i want enjoyment,
since this this web page conations really pleasant funny data
too.