CSV Export BUG? --> Total Duration
Posted: Tue Feb 03, 2015 6:08 am
Coming from here: http://www.mac-dive.com/forum/viewtopic.php?f=3&t=1834
I was trying to calculate the exact time I finished a dive as MacDive yet doesn't tell you when (hopefully soon) I exported some dives into CSV format to then import them in Excel to do the maths.
The surprise comes when I open it up in Excel and the Total Duration does not come in any date format, time or similar. It comes with a number which at first glimpse, does not look right.
Have a look:
At the top you have the exported CSV file with the Total Duration rare numbers. At the bottom the same dives within MacDive.
Nick, could you have a look into that please?
I was trying to calculate the exact time I finished a dive as MacDive yet doesn't tell you when (hopefully soon) I exported some dives into CSV format to then import them in Excel to do the maths.
The surprise comes when I open it up in Excel and the Total Duration does not come in any date format, time or similar. It comes with a number which at first glimpse, does not look right.
Have a look:
Nick, could you have a look into that please?