AnsweredAssumed Answered

Exporting Report to csv & millisecond time format

Question asked by Keith Esslemont on Dec 13, 2018

Hi All

We use a field in Sugar to record a customers "running event" time, which is a textfield and we have an issue if this field records a time with milliseconds in it. The example is a time of 01:05:19.1 and when this is exported via a report to a csv file, the formatting is lost i.e time comes out as 05:19.1

 

Is there a way to get round this? We can fix this by formatting the cell, but as we do 1000s this would not be practical.

 

 

 

 

 

Outcomes