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

    201 comments

    • Comment Link FranktaumB Tuesday, 20 October 2020 00:55 posted by FranktaumB

      kamagra 100mg oral jelly predaj: https://www.goldkamagra.com kamagra
      best doctors in usa kamagra oral jelly much kamagra jelly

    • Comment Link PorterrOr Monday, 19 October 2020 23:35 posted by PorterrOr

      buy discount cialis online were can i buy cialis where can i buy cialis cheap
      best way to buy cialis where to buy liquid cialis buy cialis over the counter usa
      how to buy cialis cheap were can i buy cialis buy cialis online us
      can i buy viagra online news about generic viagra pfizer viagra vs generic viagra
      are payday loans bad payday advance loans online payday loans tn
      last resort loans bad credit loans for veterans with bad credit

    • Comment Link 더킹카지노 Monday, 19 October 2020 23:21 posted by 더킹카지노

      You really make it appear so easy with your presentation however I to find this topic to be actually one
      thing which I believe I'd never understand. It sort of feels
      too complex and extremely extensive for me. I am taking a
      look ahead for your next publish, I'll attempt to get the hold of it!

    • Comment Link PorterrOr Monday, 19 October 2020 22:16 posted by PorterrOr

      how to buy cialis without prescription best place to buy cialis online forum buy cialis with paypal
      where can i buy cialis over the counter at walmart buy cialis generic online buy cialis 10mg
      buy cialis 5mg buy cialis online usa buy real cialis online
      when will teva generic viagra be available online viagra generic viagra without a doctor prescription india
      indian sky payday loans payday loans online bad credit real online payday loans
      loans for those with bad credit bad credit unsecured loans guaranteed approval

    • Comment Link PorterrOr Monday, 19 October 2020 19:58 posted by PorterrOr

      buy generic cialis online india best place to buy generic cialis online best place to buy cialis online
      buy cialis 5mg online buy generic cialis online where can i buy cialis without a prescription
      buy cialis generic online cheap buy generic cialis online best place to buy cialis online without script
      best site to buy viagra generic viagra costco cipla pharmaceuticals generic viagra
      online payday loans near me payday loans near me no credit check payday loans that don't require a checking account
      guaranteed signature loans for bad credit student loans for people with bad credit

    • Comment Link LeonardJoize Monday, 19 October 2020 15:20 posted by LeonardJoize

      In my opinion you are mistaken. Write to me in PM, we will communicate.

      ---
      Excuse for that I interfere Shere recently. But this theme is very close to me. Write in PM. videos animals sex, videos sex teens, тут videos sex gay

    • Comment Link LeonardJoize Monday, 19 October 2020 13:58 posted by LeonardJoize

      In it something is. I will know, I thank for the help in this question.

      ---
      Yes, it is solved. sex videos porno, sex videos dirty, тут sleeping videos sex

    • Comment Link Brianpadia Monday, 19 October 2020 05:34 posted by Brianpadia

      buy cialis uk buy generic cialis online canada where to buy cialis cheap
      where to buy cialis cheap buy cialis generic where to buy cialis over the counter
      buy name brand cialis online were can i buy cialis buy cialis on line
      is generic viagra available in the united states wikipedia female viagra generic best generic viagra
      payday loans without checking account payday loans in pa payday loans colorado
      bad credit motorcycle loans guaranteed approval pet loans for bad credit

    • Comment Link Brianpadia Monday, 19 October 2020 05:16 posted by Brianpadia

      buy cialis usa buy cialis online canada pharmacy buy cialis online uk
      buy viagra and cialis online buy cialis online without prescription buy cialis online overnight
      how to buy cialis without a prescription how to buy cialis in canada can u buy cialis over the counter
      generic viagra for sale cheap walmart indian pharmacies for generic viagra generic viagra 5 dollar first month supply
      payday loans with ssi debit card payday loans bad credit payday loans in ohio
      best private student loans bad credit bad credit long term loans guaranteed approval

    • Comment Link Robertacumn Sunday, 18 October 2020 02:26 posted by Robertacumn

      when would viagra generic be available best price generic viagra buy generic viagra in usa
      does walmart carry generic viagra generic viagra wholesale overnight generic viagra delivery
      us based generic viagra pfizer generic viagra generic viagra cheap
      generic viagra sales generic viagra professional viagra 200mg pills generic
      greenstone generic viagra generic viagra price at walmart why does generic viagra suck
      how to use viagra or generic generic viagra online canada generic viagra order canada

    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.