Using TIME to Multiply or Divide to DOLLARS

0

I want a formula to calculate the hourly rate for hours & minutes into a dollar and cent column such as

Example 1 Divide Column A into Column B to fine Dollars per Hour in Column C

                      Column A     Column B     Column C

                      H:mm                      Dollars                    Dollar / Hour

                        1:00              10.00                     10.00

                        2:00              30.00                     15.00

                        4:30              60.00                     13.33

                        3:11              50.00                     15.71

                        4:43              75.55                     16.02

Total             15:24            225.55                     14.65

Example 2 Divide Column B by Column A to Get the Dollars per Hour in Column C

                      Column A     Column B     Column C

                      H:mm                      Dollars                    Dollar / Hour

                        1:00              10.00                     10.00

                        2:00              30.00                     15.00

                        4:30              60.00                     13.33

                        3:11              50.00                     15.71

                        4:43              75.55                     16.02

Total             15:24            225.55                     14.65

Thank you

Larry

larry@*****.com

480 ********

(Edit: personal information removed.)

Answer
Discuss

Answers

0

Hi there!

=(HOUR(A1)+MINUTE(A1)/60)*B1

This gets the hour from the time and then it adds that to the minutes,which have been converted to a percentage of an hour and all of that is then multiplied by the dollar amount in column B.

Discuss

Answer the Question

You must create an account to use the forum. Create an Account or Login