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