Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Nadiyah
Contributor
Contributor

Time Format

Hello everone 

 

I'm facing an issue with the time format, the current format for the time is 06.00.00 however I can not apply any calculation in this format 

 

Is there a way to convert this format 06.00.00 to 06:00:00?

 

appreciate your support 

Labels (2)
2 Replies
BrunPierre
Partner - Master
Partner - Master

Hi

You could try this

Time(Time#('06.00.00' ,'hh.mm.ss'),'hh:mm:ss')

Bill_Britt
Former Employee
Former Employee

Hi,

To all on to BrunPierrie post, which is correct for a single value.  If you have a field you want to convert you would use Time(Time#('Fieldname' ,'hh.mm.ss'),'hh:mm:ss')

Bill - Principal Technical Support Engineer at Qlik
To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.