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 / 100Second is:
RETURN __Hours + __Minutes / 60 or RETURN __Days * 24 + __Hours + __Minutes / 60
