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.**

This is excellent, it works even for minutes and seconds.. Thanks man…