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

user_16981638 0
Viewed 33

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

excel
1 Answers

Perhaps:

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