How do I get excel to...

G

Guest

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
 
P

Peo Sjoblom

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set up a time card format in Excel 2
Employee Time calculating and tracking 1
how do I set up time worked in excell spreadsheet 1
Multiplying time by money - how? 1
Formula to sum based on a change in another column 2
excel formula to recognize overtime in a day as you prep schedule 2
if? 3
Time to and then from Midnight 1

Top