14

Suggested by Daniel Sand – Needs Votes 

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.
Comments (3)
  • Niklas Bösch
    Fri, 05 Feb 2021 12:31:27 GMT
    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.
  • Oskari Jauhiainen
    Fri, 16 Jul 2021 07:44:39 GMT
    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.
  • Ian Podmore
    Fri, 15 Nov 2024 15:25:50 GMT

    Create a new field of type calculated, then set the value of that new field with a calculation from the standard duration field divided by 60 for hours etc. Then use the new field where you want a value fixed in hours for example.

<div>Please <a id="idea-signin-link" href="/SignIn?returnUrl=%2Finsider%2Fpublic-profile%2Fideas%2Fdynamics-field-service%2FID0015024">sign in</a> to Vote and Comment on Idea.</div>

Search Ideas