Forum Discussion
Solved
Help with convertions/formula
Hi. I have a data source that gives me data formatted as: "19 min 3 sec". The cell is "standard". Is it possible to somehow convert this to only numbers, or minutes and seconds without the text? I a...
In the former formula is the time is in decimal.
here a formula in hh:mm:sec
=TID(0; VENSTRE(A1; FINN(" min"; A1) - 1); DELTEKST(A1; FINN(" min"; A1) + 5; FINN(" sec"; A1) - FINN(" min"; A1) - 5))You just need to format the cell(s) accordingly (select cell or range of cells > right mouse button > format cells... > custom > type: hh:mm:ss).
Here is an example in the file.
The formula has been adapted so that it also works from Excel 2013.
That is just great. Thank you so much for your help. Much appreciated 🙂