This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Thank you for your response. This works but, I am trying to subtract time for multiple rows in if statement.
I have a columns named [Calculation] and [DateTime_Out]. So, if calculation = "TRUE" then for that row I want to subtract time from the previous row. the data type is Time for column DateTime_Out and i am getting error
"Formula: invalid type in subtraction operator" when I am trying to use the below logic.
if [Calculation] = "TRUE" then [DateTime_Out]-[Row-1:DateTime_Out] else [DateTime_Out] endif
It looks like the formula and field formats are not consistent. The 'DateTimeDiff" formula returns a number format, not a DateTime format, so the formula you are using on the highlighted row would return '163' as a result, not 02:43:00. If you need the result in that format, you will need to change the minutes to hours (see attached workflow for example).