'how to sum hours to a start shift column that contains a text

I'm trying to add 9 hours to this column and if there's a text like (off, annual, ..etc), then put the same text. but i found an error in the generated column, is there any one have an idea to to solve this problementer image description here



Solution 1:[1]

Perhaps:

try Time.From([Start Shift]) + #duration(0, 9, 0, 0) otherwise [Start Shift]

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1