Forum Discussion
How to Split a Duration Column into Separate Columns for Days, Hours and Minutes?
Hi Anonymous
I have taken your sample data for example. please the follwing steps in PQ:
1) duplicate 2 time same column2) 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.
rsbin
Community Champion
Community ChampionAnonymous ,
Please try it this way.
In your first step, split by Delimiter, but use a period ".", not the colon.
That will give you Days, then a second column with the remainder.
Then split this column by Delimiter again, but use the Colon ":" this time.
Then you can delete the Seconds column if it of no use in your Report.
Trust this helps you on your way.
Regards,
.