Time-calculation question

[Lars]

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

 

[Ron Rosenfeld]

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

 

[Gary''s Student]

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.

 

[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: