Saved search formula to calculate duration (in hours, rounded to 2 decimal places), based on date/time fields: start date and end date

AI generated answer (using internal Slack threads):

To calculate the duration in hours between two date/time fields in a saved search, you can use a formula field. The formula would subtract the start date/time from the end date/time and multiply the result by 24 to convert the difference from days to hours. Here is an example of how you can do this: 1. Create a new formula (numeric) field in your saved search. 2. In the formula field, enter the following formula:

ROUND((TO_NUMBER({end_date_field} - {start_date_field}) * 24), 2)

Replace

{end_date_field}

and

{start_date_field}

with the actual field IDs of your end date/time and start date/time fields. This formula subtracts the start date/time from the end date/time, which gives the difference in days. Multiplying by 24 converts the days to hours. The

ROUND

function is used to round the result to 2 decimal places. Please note that this formula assumes that the date/time fields are in the same timezone. If they are not, you may need to adjust the formula to account for the timezone difference. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******