Thread: Form Guide
View Single Post
  #11  
Old 26th May 2011, 03:32 PM
Pauls123 Pauls123 is offline
Member
 
Join Date: Oct 2005
Posts: 245
Default

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
Reply With Quote