Monday, May 14, 2012

yogi_Extract Time From String Of Text In A Column Of Entries

Yogi Anand, D.Eng, P.E.       Google Spreadsheet    Post  #540    May 14, 2012

user yv6eda said:
Extracting time (hh:mm:ss) from text 
Hello again. I need some help. I have a cell range (D2:D127) filled wit the description of videos. At the end of each one I have the length of the clip. Example: (12:05) or (1:56:24). My goal, with your kindly help, is to extract this time length to E column. It's possible?
Thanks in advance...
following is a solution to the problem