Forum Discussion

acrscotland's avatar
acrscotland
New Member
9 years ago
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...
Need Help
  • DoubleJ's avatar
    DoubleJ
    9 years ago

    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

DoubleJ's avatar
DoubleJ
Solution Supplier
9 years ago

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