eta

I work in dispatch for a transportation company. My boss would like me to change the formula in the spreadsheet we use to update our customers the time that their deliveries have been made and the ETA to the rest of the deliveries for that day. Currently, I use the formula =B12+45/1440 B12 being...

Trying to create a spreadsheet which tells me the ETA to a destination but also gives the MPH based off of passing a certain point. The mph and eta to the next location would update based off the actual time entered for the previous location passed. If I were going a distance of 6150 feet which...

First, some background on what I have before we get into what Im trying to do. The Sheet pulls in data from our external database that details different repair orders. Each row has Company Name, Entry Date, Repair Order Number, Notes, etc. This sheet is used to assist in managing these orders...

Need report on Column A which are cust ID that list down week no x qty in 2 columns only Header Row 1 are week no, (Row can be dynamic too) Value are ETA qty, (if can select qty or "tbc", empty cell are ignored too) Thank to advised the vba method Initial <tbody> Cust ID / Week w01 w02 w03...

I am trying to create a sheet that shows how long a specific drive will take, by dividing the mileage in one column by 55 mph (which is not in a column) and get and answer that shows the length of time it takes in Hours : Minutes. I already have the formula, but I cannot find the correct...