Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 8838 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies
Posted

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!

Posted

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]

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

This topic is 8838 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.