Hours worked x hourly salary

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
 
D

Domenic

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!
 
J

Jerry W. Lewis

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
 
Top