Forum Discussion
Converting text time column to time column
Sorry to hear "I was able to get the years, months, days, hours, mins and seconds columns but now I am stuck.
I want to help but you need to be a bit more spefic
Click here to download a solution
Then edit the Facts table and look at each of the steps.
On the Added Custom step click on the gear wheel icon to view the formula.
Congrats you know know how to get the duration in seconds !
Please click thumbs up and accept as solution button. Thank you.
I do not understand how to get the Duration in seconds column to work.
I was able to get the years, months, days, hours, mins and seconds columns but now I am stuck.
Super UserSorry to hear "I was able to get the years, months, days, hours, mins and seconds columns but now I am stuck.
I want to help but you need to be a bit more spefic
Click here to download a solution
Then edit the Facts table and look at each of the steps.
On the Added Custom step click on the gear wheel icon to view the formula.
Congrats you know know how to get the duration in seconds !
Please click thumbs up and accept as solution button. Thank you.