Excel VB question...Please assist [RESOLVED]

[Myriad_Rocker]

I will try to explain this as well as I possibly can. I know most of you will not download files on here in fear of a virus and I understand. So, I will try to explain and illustrate as much as I can.

I have an Excel spreadsheet of...let's say truck drivers. We'll say they deliver for your local FedEx. Each time they pick up a load of packages at the terminal, they have several stops to drop all of those packages off. On the spreadsheet, I have driver name, load number, stop number, arrival date, arrival time, depart date, depart time, total time, total time in mins, & stop mins.

Now, let me explain what each one is...

Driver Name - Obviously the drivers name, or driver number, if you will

Load Number - This is the number assigned by the terminal for that load or haul

Stop Number - The number of stops, or deliveries per load. In other words, each time the FedEx guy drops a package at a house, the stop number increases by one. This is already defined and can vary from 3 stops to 10 stops.

Arrival Date - Date the package was delivered. Already populated.

Arrival Time - Time the package was delivered. Already populated.

Depart Date - Date the driver left that stop. Already populated.

Depart Time - Time the driver left that stop.

Total Time - The total time it took for that LOAD to be completed. Not that particular stop, but the ENTIRE LOAD. This needs to be calculated.

Total Time In Mins - Same as above except in minutes. This needs to be calculated.

Stop Mins - This is the total difference between arrival time and depart time, taking the date into account. This is also considered "down time." This needs to be calculated.

*all times are in standard military time8

Example Set

**not going to work...I'll post a txt file**