I have received an Excel sheet with format time: 1 min 30 secs.
How do I convert the field with string and integer format to numeric format like 90 in order to perform average?
Asked
Active
Viewed 122 times
0
pnuts
- 58,317
- 11
- 87
- 139
user2655371
- 3
- 3
-
See [this](http://stackoverflow.com/questions/11416779/converting-mmss-ms-to-seconds-using-ms-excel). – Fᴀʀʜᴀɴ Aɴᴀᴍ Nov 08 '15 at 14:45
2 Answers
1
Please try:
=LEFT(A1,FIND(" ",A1))*60+SUBSTITUTE(SUBSTITUTE(MID(A1,3,LEN(A1)),"min ","")," secs","")
pnuts
- 58,317
- 11
- 87
- 139
0
have a look at this:
=TEXT("0:"&SUBSTITUTE(SUBSTITUTE(A1," min ",":")," sec",""),"[s]")
Dirk Reichel
- 7,989
- 1
- 15
- 31
-
Why are ppl always downvoting without leaving an understandable reason? -.- – Dirk Reichel Nov 09 '15 at 12:37
-
I slowly get used to it. Just a lilbit more and i won't ask anymore :P – Dirk Reichel Nov 09 '15 at 13:47