Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Time Format with Colon

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

1 Solution

Accepted Solutions
Creator
Creator

Hi,

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

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

Thanks

Paridhi

View solution in original post

4 Replies
Creator
Creator

Hi,

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

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

Thanks

Paridhi

View solution in original post

Creator II
Creator II

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

Specialist
Specialist

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

Creator II
Creator II

Thanks Shiva it worked