Expedition Navigation Software 
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
- Nick
- Moderator
Offline
- Registered: 9/16/2015
- Posts: 2,964
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.
- 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- 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!
- 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)
- iurban
- Expert
Offline
- From: italy
- Registered: 7/23/2023
- Posts: 12
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
- Nick
- Moderator
Offline
- Registered: 9/16/2015
- Posts: 2,964
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.
- iurban
- Expert
Offline
- From: italy
- Registered: 7/23/2023
- Posts: 12
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
- Campbell_Field
- Moderator
Offline
- From: UK
- Registered: 9/16/2015
- Posts: 235
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
It may be some issue with Excel in a mac environment - it definitely works - see image:
:::Campbell Field::::::www.fieldyachting.com:::
- iurban
- Expert
Offline
- From: italy
- Registered: 7/23/2023
- Posts: 12
Re: Change CSV logfile Utc format in Excel
i tried also on my boating pc with win10 and excel world 2016, but nothing
i am starting to feel dumb