I am trying to work out a work order worksheet. I would like the "Labor Total" to equal the hours Xs one of two shop rates (88 or 60/hour), selectable via drop down menu in the labor parts cell.

I am totally confused and am quite sure I am not making much sense. I am hoping (and am certain that) there are many people here smarter and more experienced than me who are willing to help.

I have attached the file. Column L will be hidden.

With great thanks,
Sample Excel File.xls