Microsoft Idea

Duration field should have configurable format

Daniel Sand on 7/30/2020 9:54:24 AM

Currently a Duration field (Whole number, Format: Duration) saves the value in minutes and shows it in minutes, hours or days (depending on the value). It would be good to have the option to change the way how the field shows a value to a fixed format ("Always show value in hours", "Always show value in minutes", "Always show value in days").
In a lot of businesses the primary value for measuring time is hours, so a value of 30 minutes should show as 0,5 hours in the UI and a value of 2 days should show as 48 hours.
This idea is only about the UI, saving it in the DB as minutes is fine.

STATUS DETAILS

Needs Votes

Comments

RE: Duration field should have configurable format

Oskari Jauhiainen on 7/16/2021 7:44:39 AM

Seems that this idea is presented here several times under different categories. Might make sense to combine the ideas and see how relevant this is, especially from the user adoption point of view.

Category: Administration

RE: Duration field should have configurable format

Niklas Bösch on 2/5/2021 12:31:27 PM

Full support. Especially in more traditional fields this aspect is detrimental to user adoption and a regular source of errors.
Secondary ideas: It should not only be display but also data entry. Right now, you can type in minutes and it works, but users have to write "32 hours" so the field saves properly.

Category: Administration