# 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.)

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