Currently Being ModeratedJan 3, 2013 5:33 PM (in response to William Hamilton)
Simple addition will do it, provided the starting date and time is entered as a Date and Time value, and the travel times are entered and formatted as Duration values:
Durations entered as shown in column B will be recognized as Duration values automatically. Cells in the column can be formatted as Duration, using one of the other format choices, as shown below, but doing this will restrict the display to the units chosen (and require each of those units be included in the display) as shown below. The table below contains the same values as above.
The table contains one formula:
C2, and filled down: =C1+B2
Currently Being ModeratedJan 3, 2013 6:30 PM (in response to Barry)
Really appreciate your input. I think I understand. But if I want to derive a "duration" separately, ie, 240 miles / 60 mph = 4.0, how do I get that result to correctly be incorporated into the calculations? If I do that calculation, and format it as a duration, and add it to a time value, it assumes it to be days.