## Date calculation - schedule

239 Views 4 Replies Latest reply: Jan 3, 2013 8:13 PM by William Hamilton
Level 1 (90 points)
Currently Being Moderated
Jan 3, 2013 4:35 PM

I'm sure this must be simple but I can't seem to come up with an easy way to do this.  I want a worksheet that builds an itinerary for a car trip.  I would like to be able to have a start time/date, and then enter travel times for each leg.  That would then show the date and time that leg is completed.  Can someone give me a hand with this?

• Level 7 (28,870 points)
Currently Being Moderated
Jan 3, 2013 5:33 PM (in response to William Hamilton)

Hi William,

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

Regards,

Barry

• Level 7 (27,470 points)
Currently Being Moderated
Jan 3, 2013 7:28 PM (in response to William Hamilton)

William,

Assuming that Column A contains Miles and Column B contains Speed in MPH, you could write:

=DURATION(,,A/B)

Jerry

#### More Like This

• Retrieving data ...

#### Legend

• This solved my question - 10 points
• This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.