Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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
Highlighted
Master
Master

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

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

LOAD * INLINE [

TIME

36000

1440

];

View solution in original post

3 Replies
Highlighted
Master
Master

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

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

LOAD * INLINE [

TIME

36000

1440

];

View solution in original post

Highlighted
Contributor II
Contributor II

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

great! very thanks!

Highlighted
Master
Master

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

No problem at all