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

=SUM(OT_Range)

if they are integers just multiply with the OT rates, if they are Excel time
values like 04:00 etc then multiply with 24 as well

=SUM(OT)Range)*OT_Pay_Rate

=SUM(OT_Range)*24*OT_Pay_Rate


--
Regards,

Peo Sjoblom


"DerryMark" wrote in message
...
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