How to calculate wages

  • Thread starter Thread starter Michelle Steel
  • Start date Start date
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.
 
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
 
Tim,

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

PC
 
Back
Top