“Multiplying Matrices” in Microsoft Excel 2010





To calculate the payment based on the worked hours & rate, we have to multiply each time value by its matching numerical rate.

Let us take an example:

In this example, we will show you how to calculate the number of working hours say 22 hours, & do a simple multiplication with hourly rate to get the payment.

  • Column A contains time values representing worked hours.
    Column B contains hourly rates.

img1

  • In order to calculate the payment, we will multiply the hours worked with rate.
  • In cell C2, the formula would be =A2*B2*24

img2

  • Copying down the formula from cell C2 to range C3:C4, we will get the desired result.

img3

In this tip, Hours x Rate will be multiplied by 24 because Excel treats time formats quite differently than regular numbers.

One day = one whole time unit, therefore one hour = 1/24th of a whole unit, and we must multiply hours by 24 to achieve whole units of time.



One thought on ““Multiplying Matrices” in Microsoft Excel 2010

Leave a Reply

Your email address will not be published. Required fields are marked *


eight × 8 =

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>