Display work in minutres and hour RRS feed

  • Question

  • I use Project Professional 2013. Is there a way to display work in hours and minutes?

    The reason is that I have a project plan with numerous tasks with work less than an hour. Those need to be shown in minutes, as it is more convenient. There are also tasks that are more than an hour and I'd like to see those in hours.

    e.g. task of 30 minutes should show 30 mins

    task of 90 minutes should show as 1.5 hours.

    Wednesday, June 28, 2017 12:59 PM


All replies

  • HFprojects,

    Sorry, no such option. You could create a custom field to translate fractional hours to minutes, but that's about it. For example, if the work is less than 60 minutes, it would display minutes but if the work is greater than 60 minutes, it would display hours and fractional hours.


    Wednesday, June 28, 2017 1:06 PM
  • Further to John's point, you could probably create a custom field with a formula which would display the hours and minutes, using MOD and DIV type functions, eg 4 hours 28 mins;  but out of the box, no such soln exists.

    Ben Howard [MVP] | web | blog | book

    Wednesday, June 28, 2017 4:05 PM
  • Please try the task custom text field formula below: 

    ProjDurConv( [Work], iif( [Work] < 60, pjMinutes, pjHours) )

    Ismet Kocaman | eBook on Formulas

    • Proposed as answer by John - Project Wednesday, June 28, 2017 10:53 PM
    • Marked as answer by HFprojects Thursday, June 29, 2017 6:05 AM
    Wednesday, June 28, 2017 8:55 PM
  • All the above answers were excellent and I'd like to thank you for the speedy responses!
    Thursday, June 29, 2017 6:06 AM