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: 
Not applicable

Convert minutes into time.

Hi everyone,

suppose

I have a field name minutes or variable $(minutes).

I am looking to convert into time. (format hh:mm:ss.)

let me know~ master~

1 Solution

Accepted Solutions
MarcoWedel

Time( $(minutes)/(60*24), 'hh:mm:ss')

View solution in original post

6 Replies
MarcoWedel

Time( $(minutes)/(60*24), 'hh:mm:ss')

anbu1984
Master III
Master III

=Time(Time#(Minutes,'mm'))

Anonymous
Not applicable
Author

Or

time(time#($(minutes),'mm'), 'hh:mm:ss')

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try like this

=Time(Time#(variableName,'mm'), 'hh:mm:ss')

or

=Time(Time#(FileldName,'mm'), 'hh:mm:ss')

Regards,

Jagan.

chriscammers
Partner - Specialist
Partner - Specialist

Also try

=Interval($(vMinutes)/(60*24),'d hh:mm')

This will give you a number of days, hours and minutes.

Not applicable
Author

time#(variablename,hh:mm:ss)