How can I determine minute serial number values?

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
 
B

Bob Phillips

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)
 
B

Bob Phillips

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...
 
Top