I am need of producing a weekly timesheet that allows for two rates to be chosen from. Ideally, the template in Office 2011 for mac is perfect, except it is for hourly rates. I want to be able to choose from a drop down list (Travel day or Offshore Day) in one column, the column on the end for totals will automatically display the appropriate rate for the selection made. Is there anyone that can help me with the formulas? Thanks in Advance
Rdegetaire
