Newbies jabond Posted August 27, 2000 Newbies Share Posted August 27, 2000 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! Link to comment Share on other sites More sharing options...
Kurt Knippel Posted August 27, 2000 Share Posted August 27, 2000 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] =-=-=-=-=-=-=-=-=-=-=-=-= Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 8651 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 accountSign in
Already have an account? Sign in here.
Sign In Now