Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Greeley, Colorado
    Posts
    188
    Thanks
    8
    Thanked 1 Time in 1 Post

    Unix time to Excel formula not working

    I find many sites saying to use the following formula to convert a Unix data/time format to Excel date. =(A1/86400)+25569+(-9/24) where A1 contains the Unix time. I'm getting this time from another system and the example I'm using in A1 is 1461336955311. Excel says the resultant date is negative or too large to display. Suggestions for troubleshooting appreciated.

  2. #2
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,634
    Thanks
    115
    Thanked 649 Times in 592 Posts
    Hi bdesilva,

    Please check the value you are using as the Unix Date:
    1461336955311

    If you truncate the value to
    1461336955

    Your date will evaluate to 04/22/2016 5:55 using your formula.

    HTH,
    Maud

  3. #3
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,634
    Thanks
    115
    Thanked 649 Times in 592 Posts
    Forgot to mention that I formatted the cell with the formula as:

    mm/dd/yyyy h:mm

    and I assume that you want to use a 9 hour offset from GMT.

    Maud

  4. #4
    2 Star Lounger
    Join Date
    Jan 2003
    Location
    Greeley, Colorado
    Posts
    188
    Thanks
    8
    Thanked 1 Time in 1 Post
    Thanks! That solved it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •