countdown in hours

[TyronTi]

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

[TheTimeSavingCo]

Try this:

IF(
  ABS(
    DATETIME_DIFF(
      NOW(),
      {Target Date},
      'hours'
    ) 
  ) != 24,
  ABS(
    DATETIME_DIFF(
      NOW(),
      {Target Date},
      'hours'
    ) 
  ),
  "Cancelled"
)