I need to change cells with a string like 2 hrs 55 min 1 sec to h:mm:ss (2:55:01). I'd be fine if they used leading zeroes, but unfortunately they don't.
Some example data:
10 min 13 sec
1 hrs 9 min 1 sec
59 sec
2 hrs 10 min 53 sec
=IF(MID(D2,LEN(D2)+2-6-1,1)=" ",MID(D2,LEN(D2)+2-5-1,1),MID(D2,LEN(D2)+2-5-2,2)) got me the seconds into one column, but then I ran out of ideas for minutes and hours.
Any ideas would be great.
Thanks,
Tas
Bookmarks