27th May 2011, 02:07 AM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 1,096
|
|
Quote:
|
Originally Posted by Pauls123
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
|
With hindsight, if the time is always expressed in this format then this formula is simpler:
=LEFT(A1,1)*60 + MID(A1,3,4)
Cheers |