Hi

Havve been trying and failing to complete a formula, that can do the
following:

Data:

I have the travelling time in format hh:mm:ss.
I have the arrival-time at destination with date and time.

How do I calculate departure-time (If I want to arrive exactly)

Thanks for answers ;)

Lars

On Fri, 7 Mar 2008 10:59:01 -0800, Lars wrote:

Hi

Havve been trying and failing to complete a formula, that can do the
following:

Data:

I have the travelling time in format hh:mm:ss.
I have the arrival-time at destination with date and time.

How do I calculate departure-time (If I want to arrive exactly)

Thanks for answers ;)

Lars

Departure Time = Arrival_Time - Travel_Time

Format as m/d/yyyy h:mm

--ron

Straight subtraction with the proper formatting. For example, the arrival
date/time is:

7 March 2008 @6:15AM

the travel time is:

8 Hours 14 minutes

In A1 and A2 enter:

39514.26042
0.343055556

In A3 enter:
=A1-A2
It will display:
39513.91736

Now format A1 and A3:
Format Cells.... Number Custom d mmmm yyyy hh:mm
Format A2:
Format Cells... Number Custom h:mm

A1 thru A3 will now display:

7 March 2008 06:15
8:14
6 March 2008 22:01

So if you want to arrive at 6:15 AM you need to depart 10:01 PM of the
previous day.


--
Gary''s Student - gsnu200772


"Lars" wrote:

Hi

Havve been trying and failing to complete a formula, that can do the
following:

Data:

I have the travelling time in format hh:mm:ss.
I have the arrival-time at destination with date and time.

How do I calculate departure-time (If I want to arrive exactly)

Thanks for answers ;)

Lars

Thanks a lot.... I finally got it... I had been using "." to separate the
hours, minutes, and seconds... That's all that needed change...

Thanks for the fast answers!

Lars

"Ron Rosenfeld" skrev:

On Fri, 7 Mar 2008 10:59:01 -0800, Lars wrote:

Hi

Havve been trying and failing to complete a formula, that can do the
following:

Data:

I have the travelling time in format hh:mm:ss.
I have the arrival-time at destination with date and time.

How do I calculate departure-time (If I want to arrive exactly)

Thanks for answers ;)

Lars

Departure Time = Arrival_Time - Travel_Time

Format as m/d/yyyy h:mm

--ron