ExpeditionExpedition Navigation Software

You are not logged in. Would you like to login or register?

Free This forum is hosted for free by Boardhost. Create your own free forum!


  • Index
  •  » General Discussion
  •  » Change CSV logfile Utc format in Excel

    • 1 2  Jump to

     

    5/30/2023 10:10 pm  #1

    JonasLSWE
    Member

    Offline

    Registered: 1/25/2023
    Posts: 4

    Change CSV logfile Utc format in Excel

    Hi all,
    I need help to understand how I convert the Utc value in the CSV log file, I use excel for the analysis. A typical format is like below.  45059.344034
    Thanks.

    /JonasLSWE

     

    5/30/2023 10:26 pm  #2

    Nick
    Moderator

    Offline

    Registered: 9/16/2015
    Posts: 3,304

    Re: Change CSV logfile Utc format in Excel

    It is a Microsoft DATE type, so is native to Excel etc.

    You can just select the format of the cells in Excel.

     

    5/30/2023 10:42 pm  #3

    JonasLSWE
    Member

    Offline

    Registered: 1/25/2023
    Posts: 4

    Re: Change CSV logfile Utc format in Excel

    Thanks for quick reply as always.  I have tried all pre defined formats.... without any success. Pls advice which I should use. 

       •Thread Starter
     

    6/06/2023 4:52 am  #4

    wildoats
    Contributor

    Offline

    Registered: 4/07/2023
    Posts: 6

    Re: Change CSV logfile Utc format in Excel

    I use the custom setting d/mm/yyyy h:mm:ss.

    It's a custom setting. To get to it: Home tab -> Number -> "More Number Formats" (opens "Format Cells" Box) ->  Custom -> then type d/mm/yyyy h:mm:ss (alternatively scroll down the options to d/mm/yyyy h:mm then add ":ss"). Hopefully that is what you want!

    If you ever want to convert from UTC to your local time (I do this in a column to the far right so as not to muck up the log file), add your decimal time format to (the number of hours you are different from UTC/24), eg for Sydney outside daylight savings its 45059.344034 + (10/24). If you are 10 hours behind UTC, obviously its 45059.344034 + (-10/24)

    The original Wild Oats - 4343!
     

    11/06/2023 4:25 pm  #5

    fogmachine
    Expert

    Offline

    Registered: 11/14/2017
    Posts: 13

    Re: Change CSV logfile Utc format in Excel

    For those going from Expedition to Unix in Python:
                msDate = float(vals["Utc"]) # Expedition's Microsoft DATE like 45059.344034
                seconds = int((msDate  - 25569) * 86400)
                ts = datetime.datetime.utcfromtimestamp(seconds)

     

     

    10/21/2024 10:03 am  #6

    iurban
    Expert

    Offline

    From: italy
    Registered: 7/23/2023
    Posts: 18

    Re: Change CSV logfile Utc format in Excel

    Hi guys,

    could some one help me with Microsoft date?

    I can't convert to normal date and time on excel

    I read a lot of about it but I haven't find the solution

    many thanks 

     

    10/21/2024 11:22 am  #7

    Nick
    Moderator

    Offline

    Registered: 9/16/2015
    Posts: 3,304

    Re: Change CSV logfile Utc format in Excel

    It is already in the Microsoft time type.

    You just need to set the cell text format as above.

     

    10/23/2024 2:05 am  #8

    iurban
    Expert

    Offline

    From: italy
    Registered: 7/23/2023
    Posts: 18

    Re: Change CSV logfile Utc format in Excel

    sorry but I tried in different ways but nothing still struggling to have a valid reference time in my log file on excel

    I attached some screenshots 

    https://ibb.co/NNHKCkK

    https://ibb.co/vdVfYC9

     

    10/23/2024 10:43 pm  #9

    Campbell_Field
    Moderator

    Offline

    From: UK
    Registered: 9/16/2015
    Posts: 269

    Re: Change CSV logfile Utc format in Excel

    iurban wrote:

    sorry but I tried in different ways but nothing still struggling to have a valid reference time in my log file on excel

    I attached some screenshots 

    https://ibb.co/NNHKCkK

    https://ibb.co/vdVfYC9

    It may be some issue with Excel in a mac environment - it definitely works - see image: https://ibb.co/G5Zy4QG
     

    :::Campbell Field::::::www.fieldyachting.com:::
     

    10/24/2024 2:55 am  #10

    iurban
    Expert

    Offline

    From: italy
    Registered: 7/23/2023
    Posts: 18

    Re: Change CSV logfile Utc format in Excel

    i tried also on my boating pc with win10 and excel world 2016, but nothing 

    https://ibb.co/nnX5L9S

    i am starting to feel dumb
     

     

     

    1 2  Jump to

  • Index
  •  » General Discussion
  •  »  Change CSV logfile Utc format in Excel

    • Board footera

     

    Powered by Boardhost. Create a Free Forum




    Check out RaceData for iOS and Android. Expedition data in the palm of your hand, or on your wrist! RaceData

    Interested in advertising here? Over one thousand active navigators and Expedition users visit this forum. Click here to contact the administrator.