Evaluating an algebraic expression introduced as strings
I have a character column that has the duration of different processes in the following format: 3h 40min 15s3h 47min 19s5min 6s29min I changed this to another character column with find and replace:3*3600 + 40*60 + 153*3600 + 47*60 + 19
5*60 + 6
29 * 60
How can I add a formula that evaluates each expression when the expression is a string?
This works:Eval( Expr( 3*3600 + 40*60 + 15 ) )
But the formula ...