The “Time” column type is used for values that contain hours and minutes. Time columns will render the time values in the format you specify on the“wpDataTables settings“ page. Two format types are available:
- 1:25 PM (12hour)
- 13:25 (24hour)
- Rendering rules: the value is cast as time, and then formatted using the format defined in the plugin settings.
- Sorting rules: time.
- Applicable filter types: time range.
- Issues to note:
- Seconds are not yet supported.
- Global search doesn’t support search by time.
“Arrival” column in this table is of Time type.
wdt_ID | Flight | Carrier | Origin | Arrival | Term. | Status |
---|---|---|---|---|---|---|
1 | AV 42 | AVIANCA | (MDE) Medellin | 06:13 AM | 4 | Landed Delayed |
2 | NH 7814 | ANA | (MDE) Medellin | 06:13 AM | 4 | Landed On-time |
3 | AS 18 | Alaska Airlines | (SEA) Seattle | 05:20 AM | 8 | Landed On-time |
4 | AA 7039 | American Airlines | (SEA) Seattle | 05:20 AM | 8 | Landed On-time |
5 | DL 2619 | Delta Air Lines | (LAS) Las Vegas | 05:45 AM | 4 | Landed On-time |
6 | KL 6649 | KLM | (LAS) Las Vegas | 05:45 AM | 4 | Landed On-time |
7 | VS 4770 | Virgin Atlantic | (LAS) Las Vegas | 05:45 AM | 4 | Landed On-time |
8 | JJ 8414 | LATAM Airlines Brasil | (GIG) Rio De Janeiro | 05:39 AM | 8 | Landed On-time |
9 | CX 7713 | Cathay Pacific | (GIG) Rio De Janeiro | 05:39 AM | 8 | Landed On-time |
10 | AA 974 | American Airlines | (GIG) Rio De Janeiro | 05:36 AM | 8 | Landed On-time |
wdt_ID | Flight | Carrier | Origin | Arrival | Term. | Status |
- Creating editable tables and filling the table data manually
- Creating non-editable tables from Excel files
- Creating non-editable tables from Google Spreadsheets
- String columns
- Integer columns
- Float columns
- Date columns
- DateTime columns
- Image columns
- URL link columns
- E-mail link columns
- Currency/price columns, and other columns with labels
- Formula (calculated) columns
- Coloring and styling columns
- Hiding columns