=SUM(IF(ISNUMBER(RIGHT($C$24:$C$388,2)*1),RIGHT($C $24:$C$388,2)*1,IF(ISNUMBE
R(RIGHT($C$24:$C$388,1)*1),RIGHT($C$24:$C$388,1)*1 ,0)))

Entered with Ctrl+Shift+Enter

should do what you describe.

Regards,
Tom Ogilvy

Paul Bird wrote in message
...
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!