topic Re: Hours to decimal hours in QlikView

Hours to decimal hours

mr_novice — Mon, 22 Sep 2014 17:13:47 GMT

Hi all,

Sorry for my bad choice of subject. I have a time "stamp" on this format "343:36:12" - This is the result between two timestamps using "interval" function. I would like to have this in decimal form like this - 343,6. Is there an easy way to convert this?

Cris

Re: Hours to decimal hours

anbu1984 — Mon, 22 Sep 2014 17:20:43 GMT

SubField(Time_Fld,':',1) & ',' & (Replace((SubField(Time_Fld,':',2)/60),'.','')+0)

Re: Hours to decimal hours

mr_novice — Mon, 22 Sep 2014 17:35:43 GMT

Thank you Anbu. I did this because I may have negative numbers. I thought there might be a function for or a time-option for converting this...

=if(subfield(vInterval,':',1)<0,

(subfield(vInterval,':',1)*-1+(SubField(vInterval,':',2)/60))*-1,

subfield(vInterval,':',1)+ (SubField(vInterval,':',2)/60)

)