topic Text in between Time Format. in QlikView

Text in between Time Format.

Anonymous — Wed, 27 Jul 2016 03:58:53 GMT

Hi all,

i have two times, as a field namely

START_TIME

10:40:00

END_TIME

11:45:00

DURATION_TIME

01:05:00

and i found the duration between those two..

Now i want to display this duration time as 01 hour : 05 minutes : 00 seconds

Can we add text in between time format or is there any other way to achieve this..

Thanks..

Re: Text in between Time Format.

tamilarasu — Wed, 27 Jul 2016 04:17:35 GMT

Hi Kishore,

Time(DURATION_TIME,'hh') & ' hour : ' & Time(DURATION_TIME,'mm') & ' minutes : ' & Time(DURATION_TIME,'ss') & ' seconds'

if your DURATION_TIME field is in text format, you have to try like below.

Time(Time#(DURATION_TIME,'hh:mm:ss'),'hh') & ' hour : ' & Time(Time#(DURATION_TIME,'hh:mm:ss'),'mm') & ' minutes : ' & Time(Time#(DURATION_TIME,'hh:mm:ss'),'ss') & ' seconds'

Re: Text in between Time Format.

PrashantSangle — Wed, 27 Jul 2016 05:18:05 GMT

or you can try

subfield(Duration_Time,':',1)&' Hours : '&subfield(Duration_Time,':',2)&' minutes : '&subfield(Duration_Time,':',3)&' Seconds'

Regards