split Multiple dates

[#1]

hi Anil, here is sample data file attached

each date in each row , 0.5 hrs as new column without hrs, Total:2hrs needs to go I have 60 colums like this having variable no. of entries in one cell . I am working in QlikSense.

2016/05/02: 0.5 hrs
2016/08/31: 0.5 hrs
2016/11/21: 0.5 hrs
2017/02/27: 0.5 hrs
Total: 2 hrs

[MarcoWedel]

see also Split multiple dates from one cell into separate rows/records- Qlik Sesnse