miles

Hi Folks, I am trying to SUM figures with miles (mi) inside the same cell. I tried to use this already to disregard the miles unit but it gives me a #VALUE error. =SUM(SUBSTITUTE(A2:A7, "mi", "") +0) Any other suggestions? Thanks.

Hi All I'm an OK user of Access (not VBA) and seeking some assistance. I have a query that is working out the distance between postcodes in the UK. I have for example, 16 unique postcodes in one column of data, and another 16 unique postcodes in another column. I was expecting to get 16...

Our goal: Run 2018 miles in 2018. What I have done: Added multiple sheets where each runner can log their miles separately via the Google Sheet for each day of the year. What I want to do: Take the remaining miles (updated into the Total sheet in C2) and the remaining days in the year based on...

Ok, so I built a spreadsheet to track my running throughout the year and I'm trying to see what my averages are on each day of the week. Through an exhaustive search, I can only come up with the following formula =AVERAGE(IF(WEEKDAY(A2:A366)=2,B2:B366)) Column A is the Date where Column B is...

Hi All, I have a question around getting numbers after a decimal point. The data with the numbers are in column A. I've used =INT(A2) to get the number in front of the decimal point in full (as it ranges from 0 to 120) and this works fine. The issue I am having is getting the number after the...

A1:A5 = No. of Veh., Speed, Circuit in Miles, Interval (min or sec), M/P Hour. The variables in B1:B5. So a typical "what-if" would be something like the Interval must be 1 minute, the Circuit Miles is 120... what would be the other values to meet the 1 min/120 miles set requirements. Other...

I enter my mileage onto a spreadsheet for various garages. I wish to have a drop down list with the garages name & miles to & from there. In the drop down list i would need to see the name of the garage & also the miles BUT when i make my selection i would only require the mileage to be entered...

So I just want to know if this is possible. Not sure how it would work. I have a form for entering customers and a form for entering invoice details. What I want is when I select the customer on the invoice form, which is in a drop down, that I get a message box with the miles and time from...

I need cell B7 to enter the daily payment rate based on the value that is entered in cell B1. For instance, if the no. of miles traveled (cell B1) is 17 then the daily travel rate will return $10.00 (cell B7). Any help is so appreciated!! <tbody> A B 1 No miles traveled: 2 Miles...

im a bit of a rookie to Excel and I cant find an exact answer to my question. Basically I want to get picture 1( https://i.stack.imgur.com/8E5zv.png ) to do what picture 2 ( https://i.stack.imgur.com/LXJhq.png ) is showing. Its probably a really easy question. So any value total over 10,000...

Hi! First time posting but I've read millions of your brilliant messages some! I'm trying to work on a scenario and not sure how best to go about scenarios in Excel. Problem: Driver has a leased car that gets 28 MPG, and has 170 days left on his lease. He is 2000 miles before he hits his...

Hi Everyone, I hope someone has a solution for me on this. I have this macro that will combine a range of cells from daily worksheets onto a worksheet called "Mileage". My finance department has some quirky rules though. 1st, anything that is over 200 miles for a day has to be submitted...