How to calculate wages

M

Michelle Steel

Can someone please help me. I am trying to create a
worksheet that tells me: the pay rates per age x the
hours worked and then calculate the total wages paid.
COLUMN 1 COLUMN 2 COLUMN 3 COLUMN 4
AGE RATE HOURS WORKED TOTAL WAGE
26 15.1463 3.5 53.00

I cant get column 3 to change to hours and minutes format
and then give me the correct total for column 4. I have
sorted out columns 1 and 2.
Any help will be really appreciated.
 
P

Paul Corrado

Michelle,

Time is stored as part of a day, and each day has a value of 1. So if
someone worked

3:30 (3.5 hours) then use

Time Worked * 24 * Hourly Wage

HTH

PC
 
P

Paul Corrado

Tim,

Thanks, but I don't need a timesheet. Michelle could probably use some help
though.

PC
 
T

Tim Otero

lol

Sorry about that, man!

it's late...

tim

Paul Corrado said:
Tim,

Thanks, but I don't need a timesheet. Michelle could probably use some help
though.

PC
Click to expand...
 

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

wages - multiply hours and minutes by number of hours worked 6
Excel Excel calculate pay based on rate per minute 7
Time calculations for Scheduled vs Actual Employee Time and Wages 4
Time calculations for Scheduled vs Actual Employee Time and Wages 2
can anyone help with this formula 3
Formula to calculate time 1
Overtime Calculations 4
Calculations on various rates 2

Top