Days:Hours:Minutes format

[mikecrengland]

Hello All -

If I have a bucket of minutes, how do i get it formatted to:

Days:Hours:Minutes

I assume it's the interval function, but can't get it to work...

Thanks!

mike

[sunny_talwar · Accepted solution]

May be

Interval(FieldName, 'D:h:mm')

[mikecrengland]

would that work with an expression too?

[sunny_talwar]

I believe so... is it not working?

[mikecrengland]

I worked! Just one adjustment... we needed to divide by 1440 (minutes in a day) to get the right value.

Thanks!

[MarcoWedel]

another one:

Interval(Interval#(yourminutes,'m'),'d:hh:mm')

hope this helps

regards

Marco