I think I was not asking the right question on my earlier post

I usually have a cell with a value of
1 or 12* or 7*

However sometime I might have on like this
CE 13:00-22:00

I need to know how to look for this and if encountered then check th
difference between 13:00 and 22:00 to see if it is 8 hours o
greater

thanks in advance
Rod Taylo

--
Message posted from http://www.ExcelForum.com