Help calculating total hours worked times hourly rate

[cbrigham]

I'm trying to calculate total hours worked D7 x 14 (hourly rate) and have the $ amount result appear in E7

Date	In	Out	# of Hours	$14/hour
43892	0.375	0.697916666666667	=(C2-B2)
43893	0.458333333333333	0.583333333333333	=(C3-B3)	from home
43893	0.65625	0.729166666666667	=(C4-B4)	from home
43893	0.791666666666667	0.875	=(C5-B5)
		TOTAL	=SUM(D2:D6)
	h:mm AM/PM	h:mm AM/PM

Date	In	Out	# of Hours	$14/hour
3/2/2020	9:00 AM	4:45 PM	7:45
3/3/2020	11:00 AM	2:00 PM	3:00	from home
3/3/2020	3:45 PM	5:30 PM	1:45	from home
3/3/2020	7:00 PM	9:00 PM	2:00
		TOTAL	14:30
	h:mm AM/PM	h:mm AM/PM

[#2]

@cbrigham 

It's not clear where are D7 and E7, but it looks like in E7 it shall be

=D7*24*14

(1 hour in time format = 1/24 as the number) 

[#3]

@cbrigham 

Or to make the # of hours worked more clear, the formula should be:

(C2-B2)*24

formatted as number or general

[#4]

@Sergei Baklan 

oops. Should have been D6 & E6 

[#5]

@PReagan 

When I tried that formula the result is in Military Time which unfortunately is confusing to some here in the states. :) Is there a way to remedy that? 

[#6]

This works! Thank you.

[#7]

I just realized this only works if the total hours worked doesn't exceed 24?

[#8]

@cbrigham 

Please apply custom format (Ctrl+1) as [hh]:mm for the elapsed time.