On Fri, 5 Dec 2003 22:45:04 -0000, "Michael Hopwood"
wrote:

Using 13,32,32 in A1 and entering the string in B1 I get a mistake in this
line!

It does not work and the A is set to text just to make sure it is not anything
else making the problem.


Assuming your text data is in cell A1

=LEFT(A1,2)*60+MID(A1,4,2)&","&RIGHT(A1,2)

Steinar Vissebråten
http://home.online.no/~steinv