I finally have been able to import durations into Power BI that were previously shown as H:mm:ss
To do this in the excel file prior to importing I converted the duration to a text type.
This converts it into a decimal number which can then be imported and changed to Duration without creating an error as would happen previously as it would often import as a time and not be able to convert to a duration.
The only problem I have now is the durations total up to a decimal value and I’d now like to convert them back to a H:mm:ss type format in my dashboard. Also does a duration of 1 equal 1 day? I’m unsure of this and would really appreciate some clarification.
Thanks in advance