hours multiply dollar

[Steved]

Hello from Steve Dee

I have 5936:45 hours to be paid at $12.23 per hour
how do I acheive the answer please as I get $3025.27
even at $10.00 an hour it should return $59364.50 please
help.

Thankyou

 

[Debra Dalgleish]

Multiply hours*rate*24, and format the cell as currency.

 

[TC Daniel]

Your total should be: $72,602.7

Total Time X 1:00:00 X rat

how or why this 1 hour = 0.041669 is beyond me but the number looks better than $3025.2

 

[TC Daniel]

FWIW: that 1:00:00 also = 0-Jan-1900

 

[Frank Kabel]

Hi
as explanation:
Excel stores dates/times internally as numbers. 1 day = 1. Therefore 1
hour = 1/24 (which is equal to your value).
For more about date/time you may take a look at
http://www.cpearson.com/excel/datetime.htm

 

[Steved]

Thanks everyone it works fine

Cheers