Skip to main content
Announcements
July 15, NEW Customer Portal: Initial launch will improve how you submit Support Cases. IMPORTANT DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
mikecrengland
Creator III
Creator III

Days:Hours:Minutes format

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

1 Solution

Accepted Solutions
sunny_talwar

May be

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

View solution in original post

5 Replies
sunny_talwar

May be

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

mikecrengland
Creator III
Creator III
Author

would that work with an expression too?

sunny_talwar

I believe so... is it not working?

mikecrengland
Creator III
Creator III
Author

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