| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculation of hourly rate times hours times 1.5
I am using excel to work out a simple sheet to send to payroll. I wanted to
iout the normal rate of pay in one box, then the hours. This then calculates the wage. However i do not know how to do the same for time and a half. If i was to input 20 hours in time and a half i would need it to x the hourly rate then x 1.5 but i cannot get it to perform the function. Please help! eg. £9.60x20hrsx1.5 Thanks Hayley. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculation of hourly rate times hours times 1.5
Hi
With Hourly rate in A1, standard hours in B1, overtime hours in C1 =B1*A1+C1*A1*1.5 will return the total pay for all hours worked Regards Roger Govier Newbusinessbod wrote: I am using excel to work out a simple sheet to send to payroll. I wanted to iout the normal rate of pay in one box, then the hours. This then calculates the wage. However i do not know how to do the same for time and a half. If i was to input 20 hours in time and a half i would need it to x the hourly rate then x 1.5 but i cannot get it to perform the function. Please help! eg. £9.60x20hrsx1.5 Thanks Hayley. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation of full hours | Excel Worksheet Functions | |||
| How can I work out how many hours I get premium rate? | Excel Worksheet Functions | |||
| comparing a value in a cell to see if it is higher than a number | Excel Worksheet Functions | |||
| subtraction of times, convert & multiply by a conditioned rate | Excel Worksheet Functions | |||
| how to multiply h:mm value by an hourly $ rate | Excel Worksheet Functions | |||
Hybrid Mode
