Hi there, I am trying to improve the following worksheet, currently we calculate the total working hours manually...

Roster.PNG

I have been trying to use =LEFT(B10,FIND("-",B10)-1) to extract the start time and the finish time. But this wont work on the time, 4..

Also, 10.30-4* means starting from 10:30 and finish at 4pm, * represent the staff has a break time on that day and this happens on all of the staff who work 5 hours or more.

Anyone have an idea about this?

Thanks