Spliting up name and time into a new row

I have a data set that looks like this:

Name <- c("Tom (20)", "35.33L","45.44L", "Mary (18)", "45.00L", "1:25.96")  data.frame(Name)        Name  1     Tom (20)  2  35.33L  3  45.44L  4    Mary (18)  5  45.00L  6 1:25.96    

And I want to create a new column call time and put all the time values in. Any idea on how to split them up??

Want it to look like this:

  Name    Time  1  Tom (20)  35.33L  2  Tom (20) 45.44L  3 Mary (18)  45.00L  4 Mary (18) 1:25.96    

https://stackoverflow.com/questions/66684184/spliting-up-name-and-time-into-a-new-row March 18, 2021 at 11:07AM