Calculating Wages

**ryanschostag** · 12-03-2011, 03:04 AM

I need to use a formula that can calculate my own wages as follows:

First 8 hours = $8/hr
Up to 10 hours = time + 1/2 after 8 hours ($12/hr)
Up to 16 hours = double time after 10 hours ($16/hr)
Over 16 hours = the foregoing + day's pay at $64

I need a formula that take the sum of my hours and convert it to a number of pay based on the foregoing rates and conditions. Can someone please help me with this?

**ConneXionLost** · 12-03-2011, 03:34 AM

In cell J3 try:

Please Login or Register  to view this content.

Cheers,

**jpr73** · 12-03-2011, 06:18 AM

Hi,
See attached a variant with the function Vlookup and a table.
Advantage : you never change the formulas.
Best regards.

**arthurbr** · 12-03-2011, 06:49 AM

@jpr

the Vlookup idea is interesting but the calculation does not yield the correct result

@ryan

There is a small typo in Connexion's formula.( unnecessary absolute references)

Amend as follows

Please Login or Register  to view this content.

I suggest you change your formula in G3 to

Please Login or Register  to view this content.

This will allow for ending times past midnight

**DonkeyOte** · 12-03-2011, 07:18 AM

another alternative might be:

Please Login or Register  to view this content.

I agree with arthurbr that you should use a MOD based function in G if your shifts can cross midnight (and never exceed 24 hours in duration).

If you need to subtract meal times etc from your calculation modify accordingly.