So, trying to help in some automation of the companies excel sheet. We have X number trucks that we track their times for leaving and arriving. It usually runs down about 90 rows, but can vary up to 20 columns. So, i have all the date and time stuff working how i want, but before they were just manually entering the travel time under the specific truck number.
So i am looking to see if there is a way to make it so that when D3 sees "truck 1" in I3, that it will take the total time from H3 and place it in D3. Trying to make the formula as clean and as simple as possible so that people can add in more trucks later and be able to update the reference easily. I am decent with excel, but this is beyond me haha. So any help would be great thanks
So i am looking to see if there is a way to make it so that when D3 sees "truck 1" in I3, that it will take the total time from H3 and place it in D3. Trying to make the formula as clean and as simple as possible so that people can add in more trucks later and be able to update the reference easily. I am decent with excel, but this is beyond me haha. So any help would be great thanks