Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

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

1 Solution

Accepted Solutions
adamdavi3s
Master
Master

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

LOAD * INLINE [

TIME

36000

1440

];

View solution in original post

3 Replies
adamdavi3s
Master
Master

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

LOAD * INLINE [

TIME

36000

1440

];

Anonymous
Not applicable
Author

great! very thanks!

adamdavi3s
Master
Master

No problem at all