I am trying to create a worksheet for use by our company and a customer. By contract, we bill for time elapsed in increments of quarter hours with a measure of time that is free and a dollar amount per quarter hour only for full quarter hours. For example, 8am to 5pm with an hour that is not chargeable. At $15 dollars per hour, that would result in a charge of $120. Another example, 8:16am to 1pm with 45 minutes that is not chargeable at $15 per full quarter hour should produce a chargeable quarter hours of 15 and a total result of $225. All data points are fields on a spreadsheet. I just cannot seem to get the formulas to work correctly. I suspect that my cell formats are part of the issue and the formulas themselves. Can anyone assist?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Calculations using time and measurements of time intervals
Similar threads
- Solved
