Or just use FormatDuration(), which looks safe to me (documented and with adequate parameter spec.)
I understand it’s a hidden formula, but I’d use it any day over the toMinutes/Round/string manipulations. Because keeping the Duration value type and leveraging existing functionality is overall a better approach than doing the calculations and type conversions yourself.
P.S. If you want to format 2 hours 30 minutes as 2.5 hours, yes, then you’ll have to convert that to a number and append “hour”/“hours” yourself.
Hi @Bjorn_Hansell ,
being an experimental/hidden formula, there is no official documentation, you just have to so some tests with different parameters.
As a matter of fact, you should be aware that this might be discontinued.
I’d say that FormatDuration() can be considered safer than other hidden formulas, but it’s just a personal feeling and I’m sure no Codan would confirm this.