#11
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|