|
#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 | |
|
|