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