 | Exporting Time Values to Excel |
| | Q | I have followed your steps to export flight log data. However when I view the data file in excel format, all the block times are missing the colon. ie 2:08 shows as 208. How can I correct this so that a spreadsheet will calculate properly? Thanks |
| | A | I do not believe that Excel has the ability to add time values in the hours:minutes format. It treats these values as time-of-day values and not elapsed-time values. So, in order to get Excel to total your times, you have two choices ...
If you don't mind exporting your time as hours.tenths, change the Time Display format in AeroLog Pro (Options dialog) to "Hrs.Tenths". When you run the export report, Excel will then be sent the times as decimal hours, and will add them properly.
The second option is to export the times in units of minutes. AeroLog stores elapsed-time values internally in this format. For example, 1:12 is stored as 72 minutes. To get your export report template to export in this format, you need to tweak the template. Right-click on each of the elapsed time objects in your template (e.g. Block_Time, Day, Night, etc.) and un-check the ElapsedTimeFormat option. When you run the export, the values will go into Excel as integer minutes, which will add properly.
|
| |
|
