Forum Discussion
Solved
Converting text time column to time column
I have a report that provides me with the duration of time that has passed but it is a text column w/ years months, days hours mins and seconds. I'd like to convert this to a time column. Any help ...
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.
Thank you.
I helped you, now plese help me with kudo.
Please click the thumbs up AND accept as solution buttons.
Thnak you !