'/%3E%3Cdefs%3E%3ClinearGradient id='paint0_linear' x1='0' y1='0' x2='0' y2='2160' gradientUnits='userSpaceOnUse'%3E%3Cstop/%3E%3Cstop offset='.1' stop-color='%23000' stop-opacity='0'/%3E%3Cstop offset='1' stop-opacity='0'/%3E%3C/linearGradient%3E%3C/defs%3E%3C/svg%3E%0A)
Time
Summary
The Time data type is used for time operations. Internally, it is stored as an Excel-compatible fractional part of day.
Examples
| A | B | C | |
|---|---|---|---|
| 1 | Internal value | Formatted as Time | |
| 2 | 0.125 | 3:00:00 AM | |
| 3 | 0.25 | 6:00:00 AM | |
| 4 | 0.5 | 12:00:00 PM | |
| 5 | 0.75 | 6:00:00 PM | |
| 6 |
See also
- Date
- Datetime