Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

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