TotalMinutes / Temporal Layer
Convert duration values to total minutes. Returns 64-bit integer count of complete minutes.
Duration conversion examples:
| Duration | Total Minutes | Note |
|---|---|---|
| 00:01:00 | 1 | One minute |
| 01:00:00 | 60 | One hour |
| 01:30:45 | 90 | Partial minutes dropped |
| 24:00:00 | 1,440 | One day |
Common applications:
- Meeting duration
- Task timing
- Session length
- Activity monitoring Range: ±292 million years
Table
0
0
Table
Transforms
[, ...]Select
columnDuration column to convert to minutes. Partial minutes are truncated. For sub-minute precision, use seconds or smaller units.
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.