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