Hi. please help. I need to calculate the duration from Released Timestamp to 4 more timestamp ([Timestamp 1],[Timestamp 2],[Timestamp 3],[Timestamp 4])
This formula is correct if I only calculate the duration from Released Timestamp to [Timestamp 1] :
IF(ISBLANK([Released Timestamp]),0,
HOUR([Released Timestamp]-[Timestamp 1])/24)
I tried to include the other timestamp using โORโ function but I got an error:
IF(ISBLANK([Released Timestamp]),0,
HOUR([Released Timestamp]-OR([Timestamp 1],[Timestamp 2]))/24)
error :
Condition OR([Timestamp 1],[Timestamp 2]) has an invalid structure: subexpressions must be Yes/No conditions
Could you please help me with my expression?
User | Count |
---|---|
40 | |
34 | |
28 | |
23 | |
17 |