How do I multiply two cells with different cell formats?

[jparks1015]

I am trying to do this equation in excel but am not getting the right answer
80:00:00 x $13.66
The 80:00:00=hours worked (calculated from a large formula), the format is [h]:mm:ss
$13.66 is the pay (entered straight into the cell it resides in), the format is currency
The answer is get is 45.533333 which is obviously not correct.
I tried changing the format of the cell that the answer goes into but nothing gives the right answer ($1092.80)

 

[Joe4]

It is important to understand how Excel stores date and time. They are stored as numbers, specifically the number of days since 1/0/1900.
So a unit of 1 is 1 day. So hours are fractions of a day. So 80 is really 3.33 (if you temporarily go to you hour cell and format as General, you will see this).
So, in order to get what you want, you will need to multiply those two cells, and then multiply that by 24, i.e.

=A1 * B1 * 24

 

[Weazel]

maybe...with C formatted as a number

Unknown

	A	B	C

<tbody>
[TD="align: center"]2[/TD]
[TD="align: right"]13.66[/TD]
[TD="align: right"]80:00:00[/TD]
[TD="align: right"]1092.8[/TD]

</tbody>

Sheet1​

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Worksheet Formulas[TABLE="width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
[TR]
[TH="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]C2[/TH]
[TD="align: left"]=(A2*B2)*24[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

 

[jparks1015]

that worked, Thank you!

 

[jparks1015]

thank you, that worked!

 

[Joe4]

You are welcome!