Expedition Navigation Software » Change CSV logfile Utc format in Excel

JonasLSWE · 5/30/2023 10:10 pm

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

Nick · 5/30/2023 10:26 pm

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

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

JonasLSWE · 5/30/2023 10:42 pm

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

wildoats · 6/06/2023 4:52 am

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)

fogmachine · 11/06/2023 4:25 pm

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)

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

5/30/2023 10:10 pm #1

Change CSV logfile Utc format in Excel

5/30/2023 10:26 pm #2

Re: Change CSV logfile Utc format in Excel

5/30/2023 10:42 pm #3

Re: Change CSV logfile Utc format in Excel

6/06/2023 4:52 am #4

Re: Change CSV logfile Utc format in Excel

11/06/2023 4:25 pm #5

Re: Change CSV logfile Utc format in Excel

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

Board footera