How to convert (thousand of) minutes in day, hour..

[Anonymous]

Hello everybody, I have this field formatted in minutes and I would like to convert it in day, hours and minutes. Ad exemple TIME=36000 minutes I would like see it like this 2 dd 12 hh 00 mm

How to?

Very thanks

[adamdavi3s · Accepted solution]

load TIME, interval((TIME/60/24),'d.hh:mm');

LOAD * INLINE [

TIME

36000

1440

];

[Anonymous]

great! very thanks!

[adamdavi3s]

No problem at all