=VALUE(MID(E17;1;FIND("m";E17)-1))+VALUE(MID(E17;FIND(" ";E17)+1;FIND("s";E17)-FIND(" ";E17)-1))/60
should work.
tc
Hylton Conacher (ZR1HPC) wrote:
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?.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
