topic Re: Convert Fraction to Time in QlikView

Convert Fraction to Time

Wed, 13 Jun 2012 12:45:00 GMT

Hi all,

I need to convert a fraction into time format.

For example, I have 1.75 (1hr 45mins) and need to convert it to 1:45

2.25 should be "2:15" (which is 2 hours 15 minutes).

Many thanks in advance,

Matt

Re: Convert Fraction to Time

MayilVahanan — Wed, 13 Jun 2012 13:12:48 GMT

Hi,

Try this,

= Time(([Fraction field]/24), 'hh:mm')

for example, = Time((1.75/24),'hh:mm') gives 01:45

Hope it helps.

Re: Convert Fraction to Time

Wed, 13 Jun 2012 13:22:33 GMT

Hi both, thank you but that doesnt seem to work.

Just to add: I need to do this for all the values in a specific colum in my raw data, so I should probably build this into the script and call it "as Converted_Time,"... do you know how I can do this within the script?

Many thanks,

Matt

Re: Convert Fraction to Time

MayilVahanan — Wed, 13 Jun 2012 13:40:17 GMT

Hi,

Try this,

Load * , Time([FractionField]/24,'hh:mm') as Converted_Time from [Tablename];

For example,

temp:
load * inline
[
fraction
1.75

2.25
];

Load Time((fraction/24),'hh:mm') as Convert_time Resident temp;

Hope it helps.

Re: Convert Fraction to Time

CELAMBARASAN — Wed, 13 Jun 2012 15:05:22 GMT

Hi,

Check with this

Load

Time#(Floor(FractionField)&':'&(Frac(FractionField)*60),'h:m') AS Converted_Time

FROM ....

Celambarasan