how to split string containg time into hours, minutes, seconds
Dear all,
I have a column date containg time information, e.g. 10:15:20 representing 10 hours, 15 minutes, 20 seconds. Please note that hours can be more then 24 hours, eg. 150:15:20 representing 150 hours, 15 minutes, 20 seconds
I tried to split this string using cells splitter with delimiter : into datearr[0], date arr[1], date_ arr[2].
I can see the new columns after cell splitter but with out any value.
Please find attached example workflow.
Where is my mistake?
Thanks for help!
BR,
Heinz