Formula to multiply time

[Guest]

I would like to figure out how much something costs by multiplying the hourly amount by hh:mm. Using the example below I tried =SUM(D1*C1) but it doesn't work. Can it be done? An answer via e-mail would be great if possible

A B C
Start End Total time Hourly rate Total charg
=SUM(B1-A1
8:00 A.M. 12:10 p.m. 4:10 $45 ?

 

[Norman Harker]

Hi Imalap!

=C1*24*D1

Time is treated by Excel as a decimal portion of 1 day; hence the need
to multiply by 24 to convert to hours.

 

[Niek Otten]

=C2*24*D3, format as required. Ignore the automatic Excel formatting as
time.

Times are stored as fractions of a day, that explains the *24

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

I would like to figure out how much something costs by multiplying the

hourly amount by hh:mm. Using the example below I tried =SUM(D1*C1) but it
doesn't work. Can it be done? An answer via e-mail would be great if
possible!

A B C D
Start End Total time Hourly rate Total charge
=SUM(B1-A1)
8:00 A.M. 12:10 p.m. 4:10 $45

?

 

[Tod]

Try this:

=(C1*24)*D1

This will first convert time to its digital counterpart:

4:10 becomes 4.166666666....

Them multiplies that by your hourly rate. You may then
need to change the format of the cell to Number.

tod

-----Original Message-----
I would like to figure out how much something costs by

multiplying the hourly amount by hh:mm. Using the example
below I tried =SUM(D1*C1) but it doesn't work. Can it be
done? An answer via e-mail would be great if possible!

 

[Tod]

Try this:

=(C1*24)*D1

This will first convert time to its digital counterpart:

4:10 becomes 4.166666666....

Them multiplies that by your hourly rate. You may then
need to change the format of the cell to Number.

tod

-----Original Message-----
I would like to figure out how much something costs by

multiplying the hourly amount by hh:mm. Using the example
below I tried =SUM(D1*C1) but it doesn't work. Can it be
done? An answer via e-mail would be great if possible!