Forum Discussion
Duration converted to a Date Time Format
I have downloaded data from Garmin. The Elapsed time field is a General datatype and looks like this: It lands in Power BI and ends up like this: I've searched through th...
I think I figured it out. I have the field in Excel set to General
I import the data
leave it as a Date/Time
I don't transform anything but go to the Data tab in the builder and change the format to be hh:nn:ss
Ignore the 2nd 2 columns I was testing.
It would be nice though if PBI did not convert these types of data. Leave it as is. I can't figure out if that's an option or not...
James-Harpin
Resolver IV
Resolver IVHi Anonymous
I did a test of this and I got it to work by when importing the excel file selecting transform, then changing the data type to 'time'