Hours worked x hourly salary

  • Thread starter Thread starter Dave
  • Start date Start date
D

Dave

Hi

I have a time sheet which calculates my hours worked, when
I multiply my total hours worked by my hourly rate i get
an incorrect answer. Is there a formula i have to use for
this as i have noticed when i convert 35mins to a number i
get 0.02!!!

Thanks
 
Hi

I have a time sheet which calculates my hours worked, when
I multiply my total hours worked by my hourly rate i get
an incorrect answer. Is there a formula i have to use for
this as i have noticed when i convert 35mins to a number i
get 0.02!!!

Thanks
Click to expand...

Hi Dave,

Assuming that your date is in "Time" format (as your post suggests), and
assuming that your time is in A1 and your hourly rate in B1:

=A1*1440/60*B1

Cheers!
 
Or more simply
=A1*24*B1
Numerically, Excel time is just the decimal fraction of a day, so that
10:30 am is =10.5/24 formatted as time.

Jerry
 
Back
Top