26th May 2011, 03:32 PM
|
Member
|
|
Join Date: Oct 2005
Posts: 245
|
|
Thanks Iomaca for that. I just tried it and had to play with the last little bit a tad. It now works for:
=LEFT(L2,1)*60+MID(L2,3,2)+RIGHT(L2,3)
If I format the active cell to Number and 2 decimal places.
Thanks again, Paul
|