topic Converting hour to minutes in QlikView

Converting hour to minutes

Anonymous — Tue, 11 Dec 2012 21:05:51 GMT

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 !!

CELAMBARASAN — Tue, 11 Dec 2012 21:13:43 GMT

Try

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

Anonymous — Tue, 11 Dec 2012 22:06:54 GMT

Great !!!

Thanks again !!

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

CELAMBARASAN — Tue, 11 Dec 2012 22:30:40 GMT

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','$#,###.##')

Anonymous — Tue, 11 Dec 2012 22:59:14 GMT

Thanks!!