How to calculate wages

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

 

[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

 

[Paul Corrado]

Tim,

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

PC

 

[Tim Otero]

lol

Sorry about that, man!

it's late...

tim

Tim,

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

PC