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: 
fmazzarelli
Partner - Creator III
Partner - Creator III

unityconvert minute hour

Hi Community,

How to convert a value from minutes to hours in the hh: mm format?
Example
field: 65 (minute)

result: 01:05

5 Replies
sunny_talwar

May be this:

Time(Time#(Field, 'm'), 'h:mm') as Field

Capture.PNG

Chanty4u
MVP
MVP

try this not tested

=interval(Minutes/24/60, 'h:mm')

Chanty4u
MVP
MVP

its working check it

=interval(Field/24/60, 'h:mm')

fmazzarelli
Partner - Creator III
Partner - Creator III
Author

Hi,

if i use a value as 536731 using your formula I receive uncorrect result.

What's wrong?

Time(Time#(sum([MINUTI TOTALI]), 'm'), 'hh:mm')

using a value as 536731 the result is 17:31

Uhm!

sunny_talwar

Is 17.31 not the right result?