View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DerryMark DerryMark is offline
external usenet poster
 
Posts: 1
Default How do I get excel to...

I have a worksheet with operators daily hours on it.

Employee - Date/ Started/ Finished/ TotalHours/ Reserve Hrs/O/T /Call Out
/Meal Allowance

At the end of the month I input Overtime data on a word document. This is
time consuming.
Is there a formula that will grab the cells from the worksheet that has
overtime on them.
Then I could multiply the overtime by the appropriate rate.
ie;
Employee -Day - Date - Overtime - Call Out - Meal Allowance

Thanks

Mark S