https://community.qlik.com/t5/QlikView/Convert-the-time-in-string-format-to-hour-minutes-and-seconds/m-p/1514040#M600950 <P>hour ('09:14:36 AM')</P><P>Minute<SPAN>&nbsp;('09:14:36 AM')</SPAN></P> Thu, 29 Nov 2018 08:02:50 GMT kishorj1982 2018-11-29T08:02:50Z https://community.qlik.com/t5/QlikView/Convert-the-time-in-string-format-to-hour-minutes-and-seconds/m-p/1514027#M600948 <P>Hello everyone,</P><P>&nbsp;</P><P>I have a time column in the attached file. I would love to break it down to hour, minutes and seconds</P><P>Regards</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 21:48:43 GMT https://community.qlik.com/t5/QlikView/Convert-the-time-in-string-format-to-hour-minutes-and-seconds/m-p/1514027#M600948 akpofureenughwu 2024-11-16T21:48:43Z https://community.qlik.com/t5/QlikView/Convert-the-time-in-string-format-to-hour-minutes-and-seconds/m-p/1514034#M600949 <P>Hi ,</P><P>&nbsp;</P><P>Try like this .</P><P>Timestamp(Time , 'hh') as Hours,<BR />Timestamp(Time , 'mm') as Mins,<BR />Timestamp(Time , 'ss') as Seconds</P><P>&nbsp;</P><P>BR,</P><P>Saurabh</P><P>&nbsp;</P> Thu, 29 Nov 2018 07:47:05 GMT https://community.qlik.com/t5/QlikView/Convert-the-time-in-string-format-to-hour-minutes-and-seconds/m-p/1514034#M600949 saurabhwadhwa 2018-11-29T07:47:05Z https://community.qlik.com/t5/QlikView/Convert-the-time-in-string-format-to-hour-minutes-and-seconds/m-p/1514040#M600950 <P>hour ('09:14:36 AM')</P><P>Minute<SPAN>&nbsp;('09:14:36 AM')</SPAN></P> Thu, 29 Nov 2018 08:02:50 GMT https://community.qlik.com/t5/QlikView/Convert-the-time-in-string-format-to-hour-minutes-and-seconds/m-p/1514040#M600950 kishorj1982 2018-11-29T08:02:50Z