Yogi Anand, D.Eng, P.E. Google Spreadsheet Post #540 May 14, 2012 www.energyefficientbuild.com.
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?
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...
Jorge
---------------------------------------------------------------------------------------------------
following is a solution to the problem
No comments:
Post a Comment