not Less than 100; that would be a long shift. <g
Regards,
Tom Ogilvy
Ron Rosenfeld wrote in message
...
On Sun, 13 Jul 2003 12:40:03 -0700, Paul Bird
wrote:
Ron - very helpful just the sort of thing I was looking for.
One extra thing is that sometimes the shift will be referred to as UD as
in 'Unrostered Days' similarly with the number of hours worked e.g UD8
,UD10 etc.
Potentially there could be even more characters before the number of
hours e.g SSP (Shift Swap Payback) so I am looking for something that
can deal with all the variations.
I tried playing with the solution you sent but got #value error message.
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
What Tom posted should work fine, so long as the shift hours are less than
100.
--ron