PPRuNe Forums - View Single Post - Scheduling time and date with time zone changes?
Old 25th Sep 2007, 11:18
  #2 (permalink)  
stickyb
 
Join Date: Feb 2000
Location: asia
Posts: 542
Likes: 0
Received 0 Likes on 0 Posts
Try this

I assume you are using excel?

for the cells that hold the departure and arrival times, format them as custom dd/mm/yyyy hh:mm For the cell that holds the flight time, format it as custom [h]:mm

in the arrival cell put in the formula =a1+b1 or whatever the cell references are - hey presto.

You could store times zones in format [h]:mm and do the appropriate maths.
stickyb is offline