Formula to multiply time

  • Thread starter Thread starter Guest
  • Start date Start date
G

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 ?
 
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.
 
=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

Imalap said:
I would like to figure out how much something costs by multiplying the
Click to expand...
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
Click to expand...
?
 
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
Click to expand...
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!
 
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
Click to expand...
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!
 
Back
Top