calculating overtome pay

potter007

New Member
Joined
Aug 15, 2006
Messages
31
Hello

Is it the IF function to calculate total pay on the basis of the cell containing number of days and then the pay rate being £22.

So if I wanted 10 @ £22, what would the calculation be?
 

Excel Facts

Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.

ADAMC

Well-known Member
Joined
Mar 20, 2007
Messages
1,169
Office Version
  1. 2013
Platform
  1. Windows
So is ten the number or days..or the number of hours?

Can you clarify the question a little...

If it was £22 per day calculation would simply be:

=SUM(A1*B1)
Where A1 is number of days and B1 is £22
 

Richard Schollar

MrExcel MVP
Joined
Apr 19, 2005
Messages
23,707
Depends whether that's the pay rate per day or per hour or what? And then how many working hours are there in a day.
 

Lewiy

Well-known Member
Joined
Jan 5, 2007
Messages
4,284
The calculation would be 10x22 so either:
=10*22
or
=A1*B1
where A1 is the number of days and B1 is the pay rate.
 

potter007

New Member
Joined
Aug 15, 2006
Messages
31
Apologies, 10 would be number of days and £22 is in another cell but with other data, I basically have:


Normal days @ £22, in one cell
number of days in one cell

So I can't really do the basic a1*b1 calculation and I also need a variance in the calculation of 1 to 31 for the number of days.

Hope that makes sense.
 

ADAMC

Well-known Member
Joined
Mar 20, 2007
Messages
1,169
Office Version
  1. 2013
Platform
  1. Windows
whats the difference between normal days and number of days?

What classifies as a 'normal day'

Maybe you can post your worksheet, using the link at the botton of richards post above (colos HTML maker) or write the formula you need in words.
 

potter007

New Member
Joined
Aug 15, 2006
Messages
31
The formula in my head that I need is:

If a1 has (1 to 31)* £22.19

I've just deleted my worksheet so can't post that right now :devilish: :devilish:
 

ADAMC

Well-known Member
Joined
Mar 20, 2007
Messages
1,169
Office Version
  1. 2013
Platform
  1. Windows
edit*

In that case all the ssuggested formulas above will work :biggrin:

Have you tried them?

=A1*B1
Where A1 is the number of days and B1 is 22.19
Or use
=(A1*22.19)

No variance is required whatever is in A1 will be used for the calculation,,,,Give it a try :)
 

potter007

New Member
Joined
Aug 15, 2006
Messages
31
Thanks Adam, for some reason I has a more complexed calculation formula in my head :biggrin: :biggrin:
 

Forum statistics

Threads
1,181,722
Messages
5,931,673
Members
436,798
Latest member
spprtpplcm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top