Duration (Time-based) to Number

Converts a time-based duration to a numeric value and appends it as a long or double column. You can select fields such as hours, minutes, seconds, milliseconds, microseconds, and nanoseconds. If the output is a long value, it truncates the result (e.g., 1 hour 30 minutes becomes 1 hour ).
Often used to transform durations into numeric values for mathematical computations or aggregations.
Note: Only time-based durations can be converted to numbers. Date-based durations are not supported because their conversion is ambiguous (for example, the number of days in a month can vary).

Input ports

1. Type: Table
   Input table
   Input table containing duration columns.

Output ports

1. Type: Table
   Output table
   Output table with duration columns converted to numeric columns.