Calculation of hourly rate times hours times 1.5

G

Guest

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.
 
R

Roger Govier

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
 

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

Hourly rate times hours? 1
How do I calculate total pay from [h]:mm times pay rate per hour? 2
Need help with Overtime formula. 6
how do I calculate hours spent x an hourly rate? 2
Vlookup in multiples columns 1
if greater than? 1
multiply time with hourly rate 2
I need calculated time in a "real number" format 2

Top