Resolved Excel Export Totals

EITHA

New member
Joined
Jun 9, 2021
Messages
2
I'm currently in the process of getting totals for airline application entry. When trying to calculate totals for my F/A-18 time, I've found it's easiest to filter my logbook by the four F/A-18 types (A-D) and then export the results to Excel. The problem I've run across is that the totals from Excel (flights/sorties and hours), using a sum function, don't match the totals I get from any of the Logbook reports when I add up the totals between F/A-18 A+B+C+D (flights/sorties or hours). Is the problem with the data export to excel?
 

Eric Addis

Senior Support Engineer
Staff member
Joined
Jan 18, 2003
Messages
849
Location
DTW
Not that we are aware of. It is the first I've heard of it.

Are you logging in hours and tenths?

If you wish, please send us your backup via the helpdesk.
 

EITHA

New member
Joined
Jun 9, 2021
Messages
2
After glancing at the front page of this Forum I think I realized the issue. When I used the filter without a custom date range, it's filtering out all my flights from 2021. Once I set a custom date range on the filter, and exported to Excel, the totals now match.
 
Top