Guys,
I am new to excel..
I got cells with text entries like "1 Min 30 Secs" or "36 Secs". Is there a way where excel can convert 1 Min 30 Secs to 90 seconds? The name of the row is Duration, and I got around 50,000 such rows to convert. :heh:
Here is what my sheet looks like. Any help is appreciated.
Cheers
Shri.
I am new to excel..
I got cells with text entries like "1 Min 30 Secs" or "36 Secs". Is there a way where excel can convert 1 Min 30 Secs to 90 seconds? The name of the row is Duration, and I got around 50,000 such rows to convert. :heh:
Here is what my sheet looks like. Any help is appreciated.
Duration |
5 Secs |
6 Secs |
13 Secs |
14 Secs |
6 Secs |
24 Secs |
24 Secs |
3 Secs |
1 Min 58 Secs |
4 Secs |
12 Secs |
17 Secs |
11 Secs |
Cheers
Shri.