Multiplying total hours worked by pay rate to get total monthly pay

Originally Posted by jonorose

I have created a simple times sheet. When I multiply the total number of hours worked by the pay rate it for some reason treats the pay rate as a rate for 24 hours, ie. if its 36 hours multiplied by $10 it gives me $15 as the answer, when of course it should be $360.

Now, I can solve it by multiplying the result by 24, but can someone please explain why this is happening and what mistake I might be making?

Could you add the excel file?

(looks like a formatting issue..)