multiply Hrs:Mins by £Hourly Pay

R

Ric Parris

Hi
I'm trying to set up a wages check sheet and having trouble coming up with
the formula to multiply the hours worked with the hourly rate
 
F

Fred Smith

Time is stored as fractions of a day, so you need to multiply by 24 to turn
a time into hours. Try:

=a1*24*b1

Regards,
Fred
 

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

if greater than? 1
Simple Time sheet, calculate OT 2
TIME X MONEY 1
How do I multiply 1 cell x 1 cell and answer in 3rd cell? 3
Currency & hours 1
Hours multiplied by money 2
Vlookup in multiples columns 1
Calculate from time formatted cell 1

Top