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).
What a service 🙂 Yes this did translate "1 min 8 sec" to 1,13 and "1 min 13" sec to 1,26. Why not 1,8 and 1,13?
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).
- Thank you so much 🙂