View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Ken McLennan[_3_] Ken McLennan[_3_] is offline
external usenet poster
 
Posts: 90
Default Extracting time from strings

G'day there Pete, Antonio & Ron,


I've got a small problem in what was supposed to be a quick
worksheet to manipulate a shift roster. I've managed to get most of

my
ideas to operate in the real world and it was kind of coming together
until tonight.



Please excuse the delay. This is the fourth time that I've tried
to respond to you on this group and each time I've had my messages come
back with a "SpamCop" message. I've checked with my ISP and they don't
use SpamCop so somewhere along the chain I'm getting blocked.

I'll try once more to say "Thankyou" to you all for your
suggestions & advice. I've considered what you all said, and I'm
currently working on the problem still.

Unfortunately I'm not in a position to enforce validation or any
kind of uniformity. Nor am I able to distribute an add-on as per the RE
suggestion (although I've downloaded it for my own use. It looks pretty
good to me).

I thought I had the matter resolved, but discovered there was one
situation which gave me a false positive. As fate would have it, it
occurs in about 1 in 3 entries so I missed detecting over 30% of what I
wanted <g. I'm working on that bit now =)

Thanks once again for your advice and assistance. I really do appreciate
it.

See ya
Ken McLennan
Qld Australia