Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Welcome to Qlik Community! Check out our new navigation! FIND OUT MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
bibopipo
Creator II
Creator II

Converting hour to minutes

Hi,

I've a runtime field as EndtimeStamp - StarttimeStamp; by the Interval(Runtime, 'hh') I retrieve the runtime hours.

Now I would convert this value into minutes. I thought to do  hours * 60 , but it doesn't work, because the system is showing wrong values.

What I'm making wrong ?

Help !!

1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

HI

Try

=num#(text(Interval(Runtime, 'hh')))*60

View solution in original post

4 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

HI

Try

=num#(text(Interval(Runtime, 'hh')))*60

bibopipo
Creator II
Creator II
Author

Great !!!

Thanks again !!

Just one thing: which is the difference between  num  and num# ?

CELAMBARASAN
Partner - Champion
Partner - Champion

Num is to format the number values in to desired number format.

Num# is to convert string to number and also in some cases you need to mention the format of the input given to it.

Example

Num(1234567, '$#,###') results $1,234,567

Num#('$2,345.45','$#,###.##')

bibopipo
Creator II
Creator II
Author

Thanks!!