Adding/subtracting 1 or more hours for a Time Zone change

[krowe111]

I am developing a table that calculates aircraft flight times. What I want to know is how to adjust for a Time Zone difference, specifically how do I add one hour (01:00:00) to the Arrival time if I enter "+1" in the Time Zone Change cell?

Thanks for the help.


Kevin

 

[Micron]

You need to maintain the same formats for all the values and perhaps set the cell data type to hour. So you'd Sum what looks like C1+C2+C3 from your pic. However, C2 needs to be 1:00 not +1 and not 1.
That simple answer may not suffice in the future because of time zones and such. Your cell values would have to have taken that into account already.

 

[krowe111]

You need to maintain the same formats for all the values and perhaps set the cell data type to hour. So you'd Sum what looks like C1+C2+C3 from your pic. However, C2 needs to be 1:00 not +1 and not 1.
That simple answer may not suffice in the future because of time zones and such. Your cell values would have to have taken that into account already.

The problem is that some time zones are a minus value, and I have tried but it seems that you can't have a negative time, such as -01:00:00.

 

[Micron]

First, your layout is confusing. You have 1:00 at the intersection of a row labeled travel time and a column labeled departure time. So which is it? Shouldn't every value be in a column, as well as the result? What do you want in B4 of your pic - 2:00 o'clock? 3:00 o'clock? Elapsed travel time?
I can get 3:00 in B4 if C2 and C4 are formatted as Time and B4 is formatted as a number. That way I can enter -1 in C3 and get 1:00. Not clear what you want though, and I think you should change your layout, but that's just me.