Text Duration Conversion

I keep finding uses for this crazy Text to Table pattern. This one converts text durations to numeric values. Didn't know this was a thing but has come up a couple times in a matter of days. I create...

TextDuration.pbix1.1 MB

Other

Time Intelligence

Nelvbautista

Frequent Visitor

5 years ago

Hi Greg_Deckler ,

With having the same text duration format, what would the formula look like if the conversion needed for the duration would be in decimals (hhhh.mm) instead of your example above thats in dd:hh:mm:ss? Appreciate your updates.

Greg_Deckler

Community Champion

5 years ago

Nelvbautista So if you have 300 hours and 52 minutes do you want that as 300.52 or 300 + 52/60? The first one is:

RETURN
    __Hours + __Minutes / 100



or

RETURN
    __Days * 24 + __Hours + __Minutes / 100

Second is:

RETURN
    __Hours + __Minutes / 60


or

RETURN
    __Days * 24 + __Hours + __Minutes / 60