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
 
Top