Formula to subtract values in one cell only...
 

Hi

If I have a cell that contains '09:00-17:30' - is there a formula or way I can get the amount of hours worked into another cell without using text to columns to seperate the values and work it out that way?

Thanks in advance
Neil