multiply Hrs:Mins by £Hourly Pay
 

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

multiply Hrs:Mins by £Hourly Pay
 

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

"Ric Parris" <Ric wrote in message
...
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