topic Re: Covert Integer to Number in QlikView

Covert Integer to Number

rustyfishbones — Thu, 31 May 2018 15:38:05 GMT

Hi All,

I have a number 3.75, I want to convert this to a time

So my answer should be 03:45.

Regards

Alan

sunny_talwar — Thu, 31 May 2018 15:40:20 GMT

Try this

=Time#(Floor(3.75) & ':' & Frac(3.75)*60, 'h:mm')

shiveshsingh — Thu, 31 May 2018 15:54:10 GMT

Try this

=Floor(3.75) &':' & Frac(3.75)*60

MarcoWedel — Thu, 31 May 2018 22:49:21 GMT

another solution might be

=Time(3.75/24,'hh:mm')

hope this helps

regards

Marco