Decimal Duration Converter

Greg_Deckler — Fri, 17 Sep 2021 16:10:54 GMT

Kind of surprised this wasn't already out there but here is a converter for a duration in decimal form to something else. You might end up with a decimal duration when doing math on two date/time columns like:

([Date1] - [Date2]) * 1.

Conversion Measure = VAR __Value = SUM([Decimal Days]) VAR __Days = TRUNC(__Value) VAR __Hours = TRUNC ( (__Value - __Days) * 24 ) VAR __Minutes = TRUNC ( (__Value - __Days - __Hours / 24) * 24*60 ) VAR __Seconds = TRUNC ( (__Value - __Days - __Hours / 24 - __Minutes/24/60) * 24*60*60 ) RETURN __Days&":"&__Hours&":"&__Minutes&":"&__Seconds

eyJrIjoiZGRlZmJlMTctNjA1Mi00NWM2LWE1MjUtY2ZmYTIwZTkyMzVkIiwidCI6IjRhMDQyNzQzLTM3M2EtNDNkMi04MjdiLTAwM2Y0YzdiYTFlNSIsImMiOjN9

Re: Decimal Duration Converter

polymathy2017 — Thu, 16 Feb 2023 21:33:18 GMT

Thank you. This is great.

topic Decimal Duration Converter in Quick Measures Gallery

Decimal Duration Converter

Re: Decimal Duration Converter