I have text strings in a column. I need to convert the numbers to a decimal, e.g. 1 hr 51 min 54 sec would equal 1.865. However some cells will not have anything in the hour (or theoretically minutes or seconds) so columns will look like this
1 hr 51 min 54 sec
17 min 12 sec
etc.
I used isnumber with search which worked when there was an hour a minute and a second number, but gave a value error for the second row here. Any ideas?
Bookmarks