This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
@Bellave_Jayaram It becomes NaN (not a number) after listing 2 numbers.
SPLIT((SELECT(BET[On Hold Duration],[BET Title]=[_THISROW].[BET
Title])))+LIST(HOUR([On Hold Stop]-[On Hold Start])*0.04167) – this
returns no. of days each time I update On Hold...