5th January 2005, 07:33 PM
|
Member
|
|
Join Date: Jan 1970
Posts: 325
|
|
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.
|