Time.
Assuming your text data is in cell A1
=LEFT(A1,2)*60+MID(A1,4,2)&","&RIGHT(A1,2)
--
Michael Hopwood
"Steinar Vissebråten" wrote in message
...
Hi.
I can't get a output of a value entered in min, second, and two digids at
the
end into seconds.
The cell is set to text and the value is: 13,30,32
This time I want to have in another cell as 810,32 seconds
How to do this in excel?
Steinar.
|