[users] Calc: Stripping Numerics from alphanumerics strings and calculating

[Hylton Conacher (ZR1HPC)]

I have a many fields in the format of '21m 52s', with different values 
before the m and s. I would like to convert this time to a decimal value 
ie (52/60)+21. I can do this manually but I wondered if there was a way 
to do it automagically. I was thinking along the lines of using left, 
right and search but my mind maxed out and ran out of processing power.

SUM(LEFT(E17;2):(RIGHT(e17;1)))
But if I use the Left or right alone I get
Left: 21 (Correct)
Right: s (Wrong - It should read 52) (Tried changing the '1' to a '3' 
but it didn't help.

The first part acts OK and can be added to the second part but it is 
getting the second part right and dividing it by 60 before adding it to 
the first part that is causing the problems.

any ideas/solutions from the list?.
--
========================================================================
Hylton Conacher - Linux user # 229959 at http://counter.li.org
Currently using SuSE 9.0 Professional with KDE 3.1
========================================================================

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]