Table of Contents
Video tutorial
Time columns in wpDataTables
The “Time” column type is used for values that contain hours, minutes and seconds. Time columns will render the time values in the format you specify on the“wpDataTables settings“ page. Three format types are available:
- 1:25 PM (12hour)
- 13:25 (24hour)
- 13:25:45 (24 hour with seconds)
- 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:
- Global search doesn’t support search by time.
Example of a table with time columns
“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 |
Read more
- 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
