Formula for duration field, based on date/time fields: start date and end date (difference in time), for decimal fields shown as hours.

AI generated answer (using internal Slack threads):

Based on the conversations, the formula to calculate the difference between two date/time fields in hours can be achieved using SuiteScript's date/time functions. The formula to calculate the difference between two date/time fields in NetSuite is:

ROUND({ID of date field}-{ID of date field})

. This formula will give you the difference in days. If you want to get the difference in hours, you can multiply the result by 24 (since there are 24 hours in a day). So the formula becomes:

ROUND(({ID of date field}-{ID of date field})*24)

. If you want to get the difference in minutes, you can multiply the result by 1440 (since there are 1440 minutes in a day). So the formula becomes:

ROUND(({ID of date field}-{ID of date field})*1440)

. Please replace

{ID of date field}

with the actual field IDs of your start and end date/time fields. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******