Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Data Protection
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    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's avatar
James-Harpin
Resolver IV
4 years ago

Anonymous is that the desired outcome you want?

Anonymous's avatar
Anonymous
Not applicable
4 years ago

In my output? No. All it's doing is extracting the Time out of the date.

 

The purpose of pulling in this data is to answer the question: How many hours\minutes have I spent on each activity.

 

Therefore:

XC sii   | 32hrs 3minutes

Run     | 14hrs 5 mintutes

 

How can you tell PBI desktop to not change the format from the Excel file? If it stayed the way it is, I could summarize the hours