Need to calculate the mileage. Mileage rounded down for 7 and under and up for 8 minutes

Hello everyone!


This is the first time posting here. Nice to see everyone assisting others with various Excel problems.

I need help with the following problem, but first, let me start off with giving you my Office specifications.

My Office is the subscription based Microsoft 365 Apps for Enterprise, which is displayed as Microsoft Office version 2208, (Build 15601 20088 Click-to-Run)

Ok, now to the specific task I am having trouble with.


I get paid $30.00 an hour from my boss. I am an Independent Contractor. I have downloaded a Simple Service Invoice for a service oriented business like Information Technologies and this downloaded Excel file that I downloaded does not have the correct formulas for calculating my mileage driven to and from a location. I tried attaching it here, but I am not seeing it displayed as I am typing this text.

I clicked Manage Attachments here and then the upload, but I am NOT seeing my uploaded attachment included here. I do see it as a downloadable file now. So disregard.

Cells A15 through E15 are formatted with the "General" details. A15 and B15 have the description of the service performed. Cells C,D and E are blank with no data.

Cell F15 has QTY in it. Cell G15 has Unit Price in it. Cell H15 has Amount in it.

* Cell A16 has Service Fee typed in it, which I basically just want to calculate my hours spent on the client's location in it. Currently, I worked 1 hour at $30/hr and that is what I have typed into the Service Fee cell. This $30.00 is typed into the cell underneath the cell with Amount in it.

* Underneath Cell A16 in Cell A17, I have typed "Mileage" so I could add my mileage to it. I get paid the regular rate of $30.00 an hour, but the boss wants me to round down for 7 minutes or less, and calculate up if the time is 8 minutes or more. Cells A17 through F17 are currently formatted with the "General" information format. Problem I am having is: I simply typed $17.50 into cell G17 and in the H17 column named Amount, because I had driven 15 minutes to the job site. 15 minutes is 1/96th of a day. Everything looked fine to send off, so I clicked on cell H18 and then went to the Home Tab on the Excel Ribbon and I clicked on SUM to add cells H16 and H17 and the Total column showed the correct total, but also displays an error message saying "Inconsistent Formulas"

If I am paid $30/hr for my services, should the Unit Price be $30.00? If I work 2 hours then I change the Unit Price to $60.00 or I probably should know the correct formula to have Excel handle that automatically for me. Currently, the QTY does work correctly with the UNIT PRICE and does increase the Amount column by $30.00. So UNIT PRICE is my HOURLY RATE and that is fine.

The MILEAGE column is where I am having the trouble. I am paid .50 cents per minute to drive or $30.00 an hour, but I need to program Excel somewhere in F17, G17 and/or H17 to round down to the nearest 15 minutes. If I drive 7 minutes or less, than I want it to round down to the previous time. If I drive 8 minutes or more, then I want to to round up to the nearest time. For example If I leave my house at 12:00 pm and drive 7 minutes and stop at 12:07 pm then I want Excel to round down to 12:00 pm. If I lave my house at 12:00 pm and I drive 8 minutes and arrive at me destination at 12:08 pm, I would like Excel to round up to 12:15 pm

I hope that I am explaining this accurately enough. I do not know how the pasting of this spreadsheet will go, so I am trying to explain it good without knowing of you can see the actual spreadsheet.