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

Work Budget Salary vs Real Time Salary 0
Calculate Total Hours when Overlapping Occurs 0
Timecard functions and formulas 1
Resource name inside resource sheet: per person, work per hours per week 0
Calculate After hours 3
Combining If, Vlookup in formula 2
Simple Time sheet, calculate OT 2
if greater than? 1

Top