Conversion of time into percentage

[#1]

Hi all,

How can i convert hours into percentage ?

Example ,

What is the 20% Of * 8 hours

please send me the set analysis expression

Thank you,

Ramu

[sunny_talwar · Accepted solution]

May be something like this:

=Floor(0.20 * Time('8', 'h')) & 'hr ' &  Frac(0.20 * Time('8', 'h')) * 60 & 'mins'

or this:

=Interval(0.20 * Time('8', 'h')/24, 'hh:mm:ss')

[maxgro]

time (interval) is a number

8 hours in Qlik         

8/24 as 1 is a day = 24 hours

so 20% of 8 hours is

8/24 * 0.2

if you have a field f1

f1 * 0.2

then format as an interval in number tab

[Clever_Anjos]

I don´t think you need a Set Analysis, you can use regular math because time fields are stored into a numeric format

Time(yourField*0.2,'hh:mm:ss') will return 20% of yourfield time field