On 22 September, 2016 - Nick wrote: > Hi, I have some old dive data in an Excel spreadsheet that I want to import > into SubSurface, but am having some problems with some of the data. I have a > number of dives that are longer than 60 minutes, and these are held in the > CSV file in HH:MM:SS format. One dive for example is 1:09:00 (69 minutes) > but when importing the duration is showing as 1m09s. > > > > How can I import these correctly? >
You can rewrite your time to be on the format MM:SS , ie 69:09. That a working workaround. There is a bug in the csv import code. As far as i can read the bug is at xslt/csv2xml.xslt:99 <xsl:value-of select="concat(substring($time, 2, 2), ':', substring($time, 4, 2))"/> To me that looks very much like "Take minutes and seconds, and don't care about anything else. Also substring in xslt is 1-indexed, so we throw away something in the beginning. Sense this makes none. Miika: Am i just reading it wrong or how is this ment to work? //Anton -- Anton Lundin +46702-161604 _______________________________________________ subsurface mailing list [email protected] http://lists.subsurface-divelog.org/cgi-bin/mailman/listinfo/subsurface
