Monday, 25 January 2016 10:34

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

    Written by
    Rate this item
    (4 votes)

    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 number in the first cell of your Excel sheet

      inserting formula

    •  

       

    • 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

      inserting formula

    •  

       

    • 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

      formating excel cell into date

    • In the "number" tab, select Date

      formating excel cell into date 2

    •  

    • 10 Digit Unix Timestamp Converted

      timestamp converted

    •  

     

     

     

     

    Read 51264 times Last modified on Tuesday, 26 January 2016 08:30
    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.

    1408 comments

    • Comment Link Seanagoks 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 SlonHausy Wednesday, 25 May 2022 05:39 posted by SlonHausy

      ptt5k

      h3rth

      yhxu

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

      doszp

      ofi1r

      6xfm

    • Comment Link SlonHausy Wednesday, 25 May 2022 03:14 posted by SlonHausy

      9r0jp

      pzqat

      ekbu

    • Comment Link SlonHausy Tuesday, 24 May 2022 19:05 posted by SlonHausy

      7h3m9

      evptq

      wo9d

    • Comment Link Peggyanase 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 Chloemug 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 is fucking milfs in the ass okay 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.

    Leave a comment

    Make sure you enter all the required information, indicated by an asterisk (*). HTML code is not allowed.

    Unix Timestamp Converter

    Converter

    Insert your 10 digit timestamp number into the relevant field and click on view results to covert it to a readable  date.