Load from excel file

[Sharbel]

Hi ,

Need some help in converting time written in Yellow cell into data as shown in Green cells as follows:

Please find attached sample file

Appreciate your help,

Sharbel

[SerhanKaraer · Accepted solution]

Hello Sharbel,

try this:

subfield(Tuesday,'-',1) as in, subfield(Tuesday,'-',2) as out

[Sharbel · Accepted solution]

Thanks a lot