driving

Hi, I'm hoping someone can help me with a if, and/or, and vlookup formula. My formula would exist in A2 and perform a vlookup in another spreadsheet based on the value in A1, however, if A1 is blank I want A2 to return a empty cell value. I know this is possible, but I'm driving myself nuts...

Hi All, I have total units of 787 (J3) & errors of 5 (N3), cell formatted to % . Formula I Cell O3 : = N3/J3 , answer in my opinion should be around 98% , why is my formula displaying 1 % ??? Sorry if this sounds daft … but its driving me mad ! Many thanks, Russ

I'm making a travel time sheet for technicians to fill in travel, the input should be broken down based on driving time period. Between 7AM and 5 PM should be considered as standard time, before 7AM is morning, after 5 PM is Evening This is easy, the hard part for me is to break it up when there...

<tbody> input input formula (arrived on site - driving time) DRIVING TIME ARRIVED ON SITE STARTED DRIVING 1:00 15:00 14:00 3:00 19:30 16:30 18:00 3:00 gives negative number ######## - should be 9:00 </tbody> Who can help me solving above? I calculate the 'started driving time" by...

Given that I have the mileage between motorway services, I want to be able to enter the names of any two of the services to calculate the distance between them. It must be simple but it's got me baffled.

Hello All, Have a chart issue that is driving me crazy: I have a pivot table as such: Name (row labels) Number of issues Number of calls Joe 10 20 Mary 12 25 Tom 5...

My code populates names of employees that can work Sunday's. However, I have another column in my table which has skills (i.e. Banking CCTV Clients Driving). etc. I want to add a condition so that my code below will also check if the person who's available on Sunday has the skills in J2 (say...

Data I downloaded as a csv file has the information in a time stamp format <colgroup><col width="64" style="width: 48pt;" span="3"> <tbody> ON-DUTY DRIVING TOTAL 2:48 9:40 12:28 </tbody> How do I covert this data to a number?

Hi all, i have a formula that counts with certain criteria. =sum(countifs($AH:$AH,{"JAN","FEB","MAR"},$AT:$AT,A9,$BE:$BE,"RETAIL")) I want to use the same criteria but I also need an average of column CK:CK but only if it meets the above criteria. It been driving me crazy! ? thanks in advance.

I'd like to do exactly the title for cells A1 through A5830 so I can import a CSV into Exchange In the same workbook, I'd love it if I could combine C1-C5830 and D1-D5830. These are first name and last names of people I'm importing. If you can help, I'd so appreciate it! It's driving me...

Hello, I want to extract the last driving kilometer of a vehicle ID, let's say 27001 thru a ComboBox. The database is store in sheets "Data", and the number of vehicle ID is in column C while the driving kilometer is in column G. So, when I change the vehicle ID in ComboBox1 then it will...