Hours worked x hourly salary

[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

 

[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

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!

 

[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