Hello, I have a column (Named raw data) that contains a time value. The values come in the format of "_ hrs _ mins _ secs" An example is "9 hrs 20 mins 0 secs". However if there is no hour in the raw data, it fills in with “_ mins _ secs”. An example is 40 mins 57 secs. Then I have columns for Hours, Minutes, and Seconds that need to be filled out from the raw data mentioned above.
Solved by Z. Y. in 20 mins