Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

How to Split a Duration Column into Separate Columns for Days, Hours and Minutes?

  • Uzi2019's avatar
    2 years ago

    Hi Anonymous 
    I have taken your sample data for example. please the follwing steps in PQ:
    1) duplicate 2 time same column 

    2) make sure its is in duration data type all 3 columns

    3)right click on column> Tarnsform > day

     

    4) then you will get only Days. do the same for hour and mints.

       5) after doing for hour and minus you will get the desired result.

     

    I hope i answered your question.