I need to calculate the difference between two time fields for flight time tracking. Both fields are in 24 hour format (17:05), but for certain flights, the time is calculated wrong. Example...

Departure Time (Off): 22:01

Arrival Time (On): 05:05

Calculated Time (Flt_Time): 16:56

Should Be: 07:04

How can I fix this?

Current calculation is:

Flt_Time = On - Off

You can respond here or send email to [email protected]

Thanks much!

quote:

---

Originally posted by jabond:

I need to calculate the difference between two time fields for flight time tracking. Both fields are in 24 hour format (17:05), but for certain flights, the time is calculated wrong. Example...

Departure Time (Off): 22:01

Arrival Time (On): 05:05

Calculated Time (Flt_Time): 16:56

Should Be: 07:04

How can I fix this?

Current calculation is:

Flt_Time = On - Off

---

Remember that the database does NOT know that a day has passed. You know that, but you never told the computer that. Shame on you!

Do this:

(I assume you already have field for Departure and Arrival Dates, if not double shame on you. Where is your data model?)

FlightTime = If ( Arrival Date > DepartureDate, Arrival Time + 24, ArrivalTime) - Departure Time

Thus 29.05 - 22.01 = 7.04

------------------

=-=-=-=-=-=-=-=-=-=-=-=-=

Kurt Knippel

Senior Filemaker Developer

http://www.database-resources.com

mailto:[email protected]

=-=-=-=-=-=-=-=-=-=-=-=-=