Pilot logbook template
The EASA column layout (AMC1 FCL.050) as a spreadsheet for Excel and Google Sheets, with a totals sheet and a fill-in guide. Below it: a block, decimal and night-time calculator.
Total time fills itself from your UTC times (past midnight handled). Dates are DD/MM/YYYY.
| Date | Departure | Arrival | Aircraft | Name PIC | Total | Landings | Night | PIC | Co-pilot | ||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Place | UTC | Place | UTC | Type | Reg | Day | Night | ||||||
| 14/01/2026 | KJFK | 23:10 | EGLL | 06:05 | B777-300ER | G-STBA | Smith | 6:55 | 1 | 6:55 | 6:55 | ||
| 15/01/2026 | EGLL | 10:20 | LFPG | 11:25 | A320-251N | G-TTNA | SELF | 1:05 | 1 | 1:05 | |||
Flight time calculator
Times are UTC, as the EASA instructions ask. Type 0705 or 7:05.
Block time
Off-block to on-block. If the arrival time is earlier, it counts as the next day.
Hours ↔ decimal
Type 1:35 to get decimal, or 1.6 to get hours and minutes.
Night time
Civil-twilight night along the great-circle route, minute by minute.
Night time is an estimate (straight-line progress along the great circle, sun position from the NOAA approximation; climb, descent and routing are ignored, so edges can be off by a few minutes). Your airline's records take precedence.
What goes in each column
From the "Instructions for use" in EASA AMC1 FCL.050. Quoted text is the AMC wording.
| Column | What to write |
|---|---|
| Date | enter the date (dd/mm/yy) on which the flight commences— the template uses DD/MM/YYYY so the year is never ambiguous. |
| Departure / Arrival place | either in full or the internationally recognised three or four letter designator, e.g. EGLL or LHR. |
| Departure / Arrival time | All times should be in UTC.For aeroplanes, flight time runs from the moment an aircraft first moves to taking off until the moment it finally comes to rest at the end of the flight. |
| Aircraft | Type, including make, model and variant, and registration. |
| Name(s) PIC | enter the name(s) of PIC or SELF as appropriate. |
| Single-pilot / Multi-pilot | indicate whether the operation was SP or MP, and for SP operation whether SE or ME. |
| Total time of flight | may be entered in hours and minutes or decimal notation as desired. |
| Landings | indicate the number of landings as pilot flying by day or night. |
| Night / IFR | enter flight time undertaken at night or under instrument flight rules if applicable. |
| Pilot function | enter flight time as PIC, SPIC and PICUS as PIC; SPIC and PICUS time is countersigned by the aircraft PIC or FI in the remarks. instructor time should be recorded as appropriate and also entered as PIC. |
| FSTD session | enter the type of aircraft and qualification number of the device. Session time includes all exercises carried out in the device, including pre- and after-flight checks. |
| Remarks | Always: instrument time flown as part of training for a licence or rating, details of skill tests and proficiency checks, the PIC's signature if you log SPIC or PICUS, and the instructor's signature for an SEP or TMG class rating revalidation. |
| Page totals | accumulated flight time or hours should be entered in the appropriate columns and certified by the pilot in the 'remarks' columnwhen each page is completed. The Totals sheet does the sums and has a row for hours brought forward. |
Source: EASA AMC1 FCL.050 Recording of flight time, Instructions for use (a)–(j). This page is not an official EASA document; check with your authority or operator before submitting a logbook.
Questions pilots ask
Do airline pilots need to keep their own logbook?
Under AMC1 FCL.050 (c)(1), flights under commercial air transport may be recorded in a computerised format kept by the operator, and the operator should make those records available to you on request. Many pilots still keep their own copy because they need it when changing airlines or applying for a licence elsewhere.
How is night defined?
From the end of evening civil twilight to the beginning of morning civil twilight, when the sun is more than 6° below the horizon. That is the definition used by ICAO Annex 1, FAA 14 CFR 1.1 and EASA, and the one this calculator uses.
Hours and minutes or decimal?
EASA accepts either. If you convert, 1:35 is 1.58 hours (or 1.6 rounded to tenths). Keep one convention per logbook so your totals add up the same way every time.
Fly for an airline? Let your roster fill it in.
crewcrew reads your roster (photo, PDF or calendar link) and turns each sector into a logbook line. No airline portal password.
- Night time worked out the same way as the calculator above
- EASA, ICAO and Jeppesen-style logbook pages, plus a flight-hours letter
- Imports this template's columns if you start here and move later