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...
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.
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