Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !!
HI
Try
=num#(text(Interval(Runtime, 'hh')))*60
Great !!!
Thanks again !!
Just one thing: which is the difference between num and num# ?
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','$#,###.##')
Thanks!!