arrived

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

Hi guys, I am having trouble with a formula to determine the latest value on a vlookup. The following is an example: <tbody> Apples ordered 2/4/2019 Oranges backfilled 2/4/2019 Apples arrived 3/4/2019 Oranges arrived 3/4/2019 Apples backstock 4/4/2019 Oranges missing 4/4/2019...

Hello, I have a reception Im going to be keeping track of those people who arrive and I need 2 formulas to keep track of how many group of people have arrived, and of those how many of them are getting an award. I'm not sure how to attach my spreadsheet anymore since I've gone to Excel 2016 so...

i have 2 column from which i have arrived minimum value of 2 column like that i have around 65000 thousands row from which i want to highlighted the cell column from which minimum condition has arrived and if the value of both the column is similar then the first column should get highlighted...

Hi all, Ive managed to get work worksheet to only calculate a cell if text is added. This allows me to plot a suppliers delivery and only consider it once I add "- arrived " EG below A1 = 1000 B1 ( =A1 ) = 0 When delivery arrives A1 = "1000 arrived" B1 NOW RETURNS = 1000 As soon as I add...