TotalHours / Temporal Layer
Convert duration values to total hours. Returns 64-bit integer count of complete hours.
Duration conversion examples:
| Duration | Total Hours | Note |
|---|---|---|
| 01:00:00 | 1 | One hour |
| 24:00:00 | 24 | One day |
| 25:30:00 | 25 | Partial hours truncated |
| 168:00:00 | 168 | One week |
Common applications:
- Work shift calculation
- Service duration
- Resource utilization
- Operating hours Range: ±292 billion days
Table
0
0
Table
Transforms
[, ...]Select
columnDuration column to convert to hours. Partial hours are truncated. For more precise measurements, use minute or second conversions.
AsColumn
nameName for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.