Forum Discussion
Solved
Duration conversion issue (CVS)
Hi all, I'm struggling with what I feel should be a simple issue! I have a CSV file coming from some time tracking software I use. The format is HH: MM: SS and represents the duration of a task...
I just made a small working sample.
First I duplicated the Duration column. Then I used the "Split Column" function. That created 3 columns containg hours, minutes and seconds.
Hope this works with your data, too!
JJ
I just made a small working sample.
First I duplicated the Duration column. Then I used the "Split Column" function. That created 3 columns containg hours, minutes and seconds.
Hope this works with your data, too!
JJ
This is perfect, thanks!! I realized that somewhere along the line I can converted the column to something else along the way and that screwed me up. This solution has me up and running - thanks!
