Multiplying time values and numbers.





Problem:
Column C:C contains time values representing worked hours. Column D:D contains rates.
In order to calculate the payment, we would have to multiply each time value by its matching numerical rate.

Solution:
To calculate the payment, the time value must be multiplied by 24 as well as by the rate, as follows:
=A2*B2*24

Hours___Rate____Payment
22:00___$20_____440
14:00___$25_____350
27:00___$30_____810
Screenshot // Multiplying time values and numbers.
Multiplying time values and numbers.



One thought on “Multiplying time values and numbers.

Leave a Reply

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


five × 9 =

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>