Hi,
You can utilize the REGEXP_EXTRACT function to achieve this, below extracts the first two digits at the beginning of the duration string as a separate string.
REGEXP_EXTRACT(DURATION_FIELD, r"^\d{2}")
Please refer to this page REGEXP_EXTRACT to customize the logic as needed.