HHMM Calculation

[jamada]

Hi....... I'm having difficulties with the following

B26 = 9:48 format set to HH:MM
C26 = .80 format set to number

I would like D26 to equal 9:48 * .80 (Nine hours 48 minutes times eighty cents.

Thanks
Jamada

 

[VoG]

Try

=24*B26*C26

Format as Number.

 

[Andrew Poulsom]

Like this?

=B26*24*C26

 

[doofusboy]

Try this:

=(TEXT(B26,"[mm]")/60)*C26

 

[jamada]

Hi all....... I tried the 3 solutions and still cant get th edesired result.

I need nine hours and 48 minutes to be multiplied by .80 a minute ?

Tks

 

[VoG]

What result are you expecting?

Excel Workbook
	B	C	D
26	09:48	0.8	7.84
Sheet1

 

[Andrew Poulsom]

Like this?

=B26*24*60*C26

 

[jamada]

9 Hours = 540 Minutes
+ 48 minutes
= 588 minutes

588*.80 = $470.40

 

[jamada]

Andrew YES!!!!

Thank You, to every one for the help.

Jamada