I am trying to create a trip log for tracking trip and tax info. I have receievd some valuable tips from another thread however it has now grown beyond that thread so I will start over. The most recent problem is a round trip consists of more than one entry, I have attached what I have so far with 2 sample trips and an explanation of how the tracking should work. Each destination should track seperately and fill in the corrosponding blanks on the totals sheet except for the "non Working" destination which should be ignored by the meals column and the time columns. Any help would be greatly appreciated. I am using excel2003 but it should be compatible with all the latest versions.
Trip time should be the total round trip time so F6 could be blank and F7 should be 18:45 ((C6-E7 total). Wait time should be G6 blank and G7 9:10 (E6-C7 diff). Meals column should be M6 blank and M7 based on F7 and in this case be 3.
I don't know how to account for the varibles.
Round trips are not always to the same destination and sometiMes there are short trips within a round trip which would use 3 rows, for exampl row 1 would be MJ - SC, row 2 SC-SC, row 3 SC - MJ, so the trip time would go from row 1 start to row 3 end and the meals would be based on the total round trip time.
In the second example F9 & F10 could be blank, F11 should be 19:30 (C9-E11 total). G9 would be blank, G10 should be 4:00 (E9-C10 diff), G11 should be 4:00 (E10-C11 diff). M9 & M10 should be blank and M11 should be 3 (from F11).
previuos thread: http://www.excelforum.com/showthread.php?t=640665
Bookmarks