I am building a time sheet for work. I am needing to get cells E10:D10 to subtract into cell F10 if the list item 6: Travel Time has been selected.

For Example:
Cell A10= 6: Travel Time
Cell F10= Recognizes that travel time has been selected and subtracts cell E10:D10 and enters the total amount.

Another Example is:
Cell A11= 1: Office Time
Cell G11= Recognizes that Office Time has been selected and subtracts cell E10:D10 and enters the total amount.

I have already built the control page and the list into the worksheet. I am not that good with all the formulas and macros associated with Excel yet. I have been working with it a lot as of late and part of the degree I am getting has associated me with Excel on a regular basis.

Any help is greatly appreciated.

Thanks
John