Difference Between Two Times Sometimes Longer Then 24 Hours

[chummers]

Hey All,

I am trying to represent the time it took to complete a task.  My data is below.  Trying to get the differene between 'Execution Time' and 'Conf. Time'.  So in this case, I would want Power BI to return "02:17".  Sometimes this value will be greater than "24:00".  How can I have this data represented in Power BI?  It is easy in Excel, but not so straight forward in BI.

[Greg_Deckler · Accepted solution]

You want Chelsie Eiden's Duration:

https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/m-p/793639?search-a...

[chummers]

Thanks!  Will this account for times greater then 24 hrs?  I.e will it return that it took 36 hours to accomplish the task?