View Single Post
  #41  
Old 5th January 2005, 07:33 PM
brave chief brave chief is offline
Member
 
Join Date: Jan 1970
Posts: 325
Default

That didn't quite work, but you got me experimenting Shaun.

I have to do 2 functions, but it works now.

=IF($M1 <> 0, REPLACE($M1, 4, 1, "."), 0)

this converts (34:41) into (34.41), then in the next column i use:

=IF($N1 <> 0, MID($N1, 2, 5), 0)

thus, giving me 34.41.
This will save me a lot of time, thx mate.
Reply With Quote