https://community.qlik.com/t5/App-Development/Load-from-excel-file/m-p/2031544#M84967 <P>Hello Sharbel,</P> <P>try this:</P> <LI-CODE lang="markup">subfield(Tuesday,'-',1) as in, subfield(Tuesday,'-',2) as out</LI-CODE> Mon, 30 Jan 2023 13:03:43 GMT SerhanKaraer 2023-01-30T13:03:43Z https://community.qlik.com/t5/App-Development/Load-from-excel-file/m-p/2031517#M84962 <P>Hi ,</P> <P>Need some help in converting time written in Yellow cell into data as shown in Green cells&nbsp;as follows:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sharbel_0-1675080653331.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/99147iA99F2A7F23E1138C/image-size/medium?v=v2&amp;px=400" role="button" title="Sharbel_0-1675080653331.png" alt="Sharbel_0-1675080653331.png" /></span></P> <P>Please find attached sample file</P> <P>Appreciate your help,</P> <P>Sharbel</P> Mon, 30 Jan 2023 12:16:43 GMT https://community.qlik.com/t5/App-Development/Load-from-excel-file/m-p/2031517#M84962 Sharbel 2023-01-30T12:16:43Z https://community.qlik.com/t5/App-Development/Load-from-excel-file/m-p/2031544#M84967 <P>Hello Sharbel,</P> <P>try this:</P> <LI-CODE lang="markup">subfield(Tuesday,'-',1) as in, subfield(Tuesday,'-',2) as out</LI-CODE> Mon, 30 Jan 2023 13:03:43 GMT https://community.qlik.com/t5/App-Development/Load-from-excel-file/m-p/2031544#M84967 SerhanKaraer 2023-01-30T13:03:43Z https://community.qlik.com/t5/App-Development/Load-from-excel-file/m-p/2031560#M84968 <P>Thanks a lot</P> Mon, 30 Jan 2023 13:44:33 GMT https://community.qlik.com/t5/App-Development/Load-from-excel-file/m-p/2031560#M84968 Sharbel 2023-01-30T13:44:33Z