number of hours by the rate

[lezawang]

Hi
I subtract end time from star time and then change the format to h:mm and then to find the total, I multiple the rate by # of hours. Instead of getting 40, I got 16!
I know one way to fix that, is to divide "# of hours" by 24 and then multiple the result by the rate. Is there any better way to do that? so multiplying # of hours by the rate will give me the right answer?
Thank you very much.

Book3
	A	B	C	D	E	F	G	H
1	start time	end time	# of hrs				rate	10
2	6:00	10:00	4:00
3
4		total	16:00
Sheet7

Cell Formulas
Range	Formula
C2	C2	=B2-A2
C4	C4	=C2*H1

 

[JimM]

You need to multiply the 'hours' by 24
=C2*24*H1

Also format cell C1 as a number!