How can I determine minute serial number values?

  • Thread starter Thread starter SethChancy
  • Start date Start date
S

SethChancy

I am trying to set up a travel itinerary - and I want to find serial
number values for duration of time. How can I do this?

Optionally: what I am trying to do is to set in the time of travel
between two points, the length of time that I will be there and so on
so that I can see how my itinerary will be affected depending on the
length of stay in an area. This is important to calculate and adjust as
I am dealing with ferry schedules here in western Norway. Anyone have a
better idea of how I can do this?

Thank you for any assistance anyone can provide.

Seth
 
Seth,

Time is a serial number, you see it as say 08:00 because it is formatted
that way. If you format as general, you will see it as .333, so you can
multiply by 24 to get a decimal value for hours.

Using this, you can then just add up the times, add these to a start date ,
and get anything you want.

As an example, say A1 has your start date, say 11/11/2003, and B1 has your
start hours, say 8 (for 8.00am)
In B2, put the first travel time, say 2 (for 2 hours), and in C1 put the
time at this place, say 24 for 1 day
Then A2 becomes =A1+(B2+C2)/24, and so on and so forth.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Seth,

By the way, if you put time in B2, C2 etc (02:00 and so on), you don't need
to divide by 24, just

=A1+(B2+C2)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Bob Phillips said:
Seth,

Time is a serial number, you see it as say 08:00 because it is formatted
that way. If you format as general, you will see it as .333, so you can
multiply by 24 to get a decimal value for hours.

Using this, you can then just add up the times, add these to a start date ,
and get anything you want.

As an example, say A1 has your start date, say 11/11/2003, and B1 has your
start hours, say 8 (for 8.00am)
In B2, put the first travel time, say 2 (for 2 hours), and in C1 put the
time at this place, say 24 for 1 day
Then A2 becomes =A1+(B2+C2)/24, and so on and so forth.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
Click to expand...
 
Back
Top