topic Time Format with Colon in QlikView

Time Format with Colon

mandilicious — Wed, 25 Nov 2020 16:16:04 GMT

Hi All

Please assist i need to format below time to have the colon ( : ) be like 03:00:35 and 00:07:51 or what can use to have those colon(:) between.

Thanks

Anonymous — Fri, 05 May 2017 09:07:15 GMT

Hi,

By using Time or Time# and give the format what ever you want.

like-TIME(field,'HH:MM:SS')

Thanks

Paridhi

mandilicious — Fri, 05 May 2017 09:15:24 GMT

Hi Paridhi

Thank you very much for your respond:

Quick one to get AVG Waiting Time i used this expression =AVG(waiting_time)

how will i add my formula to the one you gave me now?

Thanks

Anonymous — Fri, 05 May 2017 09:19:33 GMT

Like this?? TIME(AVG(waiting_time),'HH:MM:SS')

mandilicious — Fri, 05 May 2017 09:23:33 GMT

Thanks Shiva it worked