Hello,
we would like to find a formula to count down 24 hours and end at 0 or if possible marked "canceled".
if anyone can help us i will be really grateful
thanks in advance
countdown in hours
+2
+31Try this:
IF(
ABS(
DATETIME_DIFF(
NOW(),
{Target Date},
'hours'
)
) != 24,
ABS(
DATETIME_DIFF(
NOW(),
{Target Date},
'hours'
)
),
"Cancelled"
)
Login to the community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.