Different between two times......

[matthewjones108]

Hi all!



I am creating a database for a project based on an airline, and have Take off time, and Landing Time. I have used

DateDiff("n",[Landing Time],[Take off time])

But I cant seem to get it to put in the format of a time, and some of the times will go into minus if the flight goes to a different time zone in the world. Any help appreciated!

Matthew

[R_Badger]

I am going to assume you want the time for flight duration (you never specified exactly what you wanted to get).

First thing you need to do is identify the timezone (kind of like doing fractions you can't do the maths without first getting a common denominator). I suggest using the military convention as shown here:

http://www.timeanddate.com/library/abbreviations/timezones/military/a.html

This means the table needs two new fields ([Landing_TZ],[Take_off_TZ])

So now you can convert your times to the same time. I suggest using GMT as it is the international standard even if people do call it by different names.

you can then use FORMAT see:

http://msdn.microsoft.com/en-us/library/aa195902%28v=office.11%29.aspx
and here for more on date/time specifics
http://msdn.microsoft.com/en-us/libr...ice.11%29.aspx

This would probably be best run in VB to calculate this by the way.

[matthewjones108]

Yes, the flight time is what I wanted! Thank you!

So, need to make the new fields, and then put the calculation in e.e. 14.45+4 (4 being the + time zone) ?

Thanks