F
F135FTE
Finally figured out how to calculate a time difference and would like to
convert it to a format that is used in my workplace.
If I enter a landing time of 16:30 and a takeoff time of 17:36, the total
flight time is 1:06. However, our format is decimal-based, not
hours:minutes. That is, for this example, the total flight time would be 1.1
hours. If the total flight time is 1:08, it would still be 1.1 hours
(rounded off). It would go up to 1.2 hours when the flight time changed to
1:09.
Is there a formula that can inputted into the expression builder that would
convert the total flight time from hours:minutes to decimal?
convert it to a format that is used in my workplace.
If I enter a landing time of 16:30 and a takeoff time of 17:36, the total
flight time is 1:06. However, our format is decimal-based, not
hours:minutes. That is, for this example, the total flight time would be 1.1
hours. If the total flight time is 1:08, it would still be 1.1 hours
(rounded off). It would go up to 1.2 hours when the flight time changed to
1:09.
Is there a formula that can inputted into the expression builder that would
convert the total flight time from hours:minutes to decimal?