Anthony Chilco wrote:
Hi Hylton,
Hi Anthony,
Please bottom post in future.
=VALUE(MID(E17;1;FIND("m";E17)-1))+VALUE(MID(E17;FIND("
";E17)+1;FIND("s";E17)-FIND(" ";E17)-1))/60
should work.
Should and does in most cases, but sometimes doesn't ie if the initial
value is 0 or the value is similar to 1h 6m 02s . I decided that in
future I'll just calculate it manually. It also means I don't have to
edit a 4 foot long formula, which I have to admit I barely understand :)
Thanks though.
--
========================================================================
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]
