This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Enhancement of Formula Field Formatting to Support Day-Level Durations

Showing results for 
Search instead for 
Did you mean: 
7 - App Architect
7 - App Architect
Status: New Ideas

What is the proposed idea/solution?

The Duration field now supports days in addition to hours and minutes. However, the formatting options for the Formula field, when the output is formatted as a date, do not accommodate this change. As a result, I cannot use DATETIME_DIFF() to calculate a duration of many days without resorting to the same steps required before the Duration field supported days.

How does it solve the user problems?

By allowing the Duration field to support days, users can more easily track and calculate longer periods of time directly within the field. This streamlines the process and reduces the need for complex workarounds previously necessary to handle durations extending beyond hours and minutes.

How was this validated?

The issue was identified and validated during the development and testing of an interface. Testing scenarios where users attempted to calculate durations of many days highlighted the lack of appropriate formatting in the Formula field as a significant pain point.

Who is the target audience?

The target audience includes users who need to track and calculate extended periods, such as project managers, event planners, and anyone involved in long-term scheduling or time tracking. These users will benefit from more straightforward duration calculations and improved usability of the Duration field.