I'm a hard-core top poster. Sorry if that bothers you, but I treat email more as a conversation then documentation. I dislike having to go over the entire thread to get to the latest addition. I know there's arguments for both methods, and I feel it's best to take what comes and make the best of it.
tc
Hylton Conacher (ZR1HPC) wrote:
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.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
