Thread: Time.
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Michael Hopwood Michael Hopwood is offline
external usenet poster
 
Posts: 37
Default 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.