Skip to main content

countdown in hours

  • February 28, 2024
  • 1 reply
  • 16 views

Forum|alt.badge.img+2

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

1 reply

TheTimeSavingCo
Forum|alt.badge.img+31

Try this:

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