Convert 24 hr time to 12 hr format

[dk1988]

hey there,

how would i go about creating a formula column where if a timestamp from a column (let's call that column "timestamp") is older than 24 hrs, then the resulting value would be "follow up", otherwise the resulting value would be "do not follow up"

Thanks!!

[ProsperSpark]

HI DK1988,

Yes! This is certainly possible. 

In Airtable, you can use the IF function along with NOW() and DATETIME_DIFF functions to achieve this. Here's a formula that you can use in a new formula column:

------------

IF(
DATETIME_DIFF(NOW(), {timestamp}, 'hours') > 24,
'follow up',
'do not follow up'
)

----------------

This formula compares the difference in hours between the current time (NOW()) and the timestamp in the {timestamp} column. If the difference is greater than 24 hours, it returns 'follow up'; otherwise, it returns 'do not follow up'.

This should do the trick!  Good luck and please reach out if there is anything else we can help with!  Prosperspark.com