How to convert duration column to date/time column

[heejinyune]

Hello community! 

I want to convert duration (time) column to the date/time column with some calculation.

For example, my table is like this:

once model build start the step 1 happened with those duration and move on to next step. When the model finished all the 4 steps it will finish the operation and recorded the date/time in the model_build_end column. 

I wanted to create Gantt chart with this table. To show every steps duration within the timeframe. 

However, I couldn't create Gantt chart with multiple duration so want to convert duration with datetime data type.

If anyone knows how to create query like this? 

For example, step 1 column data should be convert 2022/10/22 13:21:00 pm + 03:22:32 so it have to be 2022/10/22 16:43:32pm.

Thank you! 

[Bifinity_75 · Accepted solution]

Hi heejinyune, try this:

1.- Split column "Step 1" by delimeter ":"

2.- The result is something like this:

3.- Change the result to format number:

4.- Create a custon column with this formula:

5.- Result:

6- Apply the same rules to another Steps

Best regards