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

Sean's avatar
Sean
Community Champion
9 years ago

Alternatively :smileyhappy:

Add Column tab => select column => Time button => Hour

repeat 2 more times  => select column => Time button => Minute and then again for a Second column

 

 

DoubleJ's avatar
DoubleJ
Solution Supplier
9 years ago

nice solution!