Formula field to show minutes duration between a date/time field and {now}

AI generated answer (using internal Slack threads):

Based on the conversations, to calculate the minutes duration between a date/time field and the current time (now), you can use a formula in a saved search. The formula would look something like this:

ROUND((SYSDATE - TO_DATE(TO_CHAR({your_date_field},'DD.MM.YYYY HH24:MI'),'DD.MM.YYYY HH24:MI'))*1440)

This formula calculates the difference between the current system date/time (SYSDATE) and your date/time field. The TO_DATE and TO_CHAR functions are used to format the date/time field correctly. The result is then multiplied by 1440 to convert the difference from days to minutes. Please replace

{your_date_field}

with the actual field ID you want to compare with the current time. Please note that the

0.333333333

value in the formula is a timezone offset from SYSDATE. You may need to adjust this value based on your timezone and consider daylight savings if applicable. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******