Converting hour to minutes

[Anonymous]

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 · Accepted solution]

HI

Try

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

[Anonymous]

Great !!!

Thanks again !!

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

[CELAMBARASAN]

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]

Thanks!!