VBA - If a value matches a text string then

Hi Guys,

I have another problem today:

I've got a rather lengthy process at the moment to look in the cell that shows a shift in the format "8.30am - 4.30pm" and then the formula eventually tells you how many hours have been worked in the shift written.

I've approached this with a mixture of LEFT, RIGHT, LEN, FIND, SEARCH and ABS to get the end result.

I've started to write a UDF for this process but I'm stuck trying to get it to do the following. I've written this in VB but it doesn't work as intended:

Please Login or Register  to view this content.

I'm not sure if you can use = for text strings; I guess not...

Can anyone help?

P.S. My VBA for this will probably be quite a lengthy bit of code as I'm a complete beginner - I would be looking to post my end result later on to see if anyone has any tips on improving etc.