Task Info: show duration in calendar days

  • 1
  • Question
  • Updated 1 month ago
Greetings!

  Is there a way to show duration task duration in calendar days?
  My client requested to show calendar duration instead of workdays.

Thank you.

Photo of Andrey Kazak

Andrey Kazak

  • 247 Posts
  • 21 Reply Likes

Posted 1 month ago

  • 1
Photo of Nick Duffill

Nick Duffill, Champion

  • 605 Posts
  • 248 Reply Likes
The duration of a task is in Working Days because tasks use the project management formula

Effort = Resources x Duration

You can work in calendar days by setting the map calendar so that there are 7 working days in a week, but if you use scheduling, MindManager will schedule tasks at the weekends.

Photo of Andrey Kazak

Andrey Kazak

  • 247 Posts
  • 21 Reply Likes
Nice trick.
However, can I get a difference between start and end dates using a formula to calculate the number of calendar days?
Photo of Nick Duffill

Nick Duffill, Champion

  • 605 Posts
  • 248 Reply Likes
Unfortunately the start date and due date cannot be used in Formulas. However the calendar duration could be calculated with a macro and written to a topic property. At the moment I can't think of another solution but maybe there is one.
Photo of Ary Velstra, Expert Trainer

Ary Velstra, Expert Trainer

  • 1885 Posts
  • 337 Reply Likes
I think you could educate your client a bit.
My guess is that he ( and you) will be better off if you teach him how to read a Gantt chart
A Gannt chart has the calender info.
You could use that to show the consequences of his scope creep.
(Edited)
Photo of Andrey Kazak

Andrey Kazak

  • 247 Posts
  • 21 Reply Likes
Yes, I agree.
But this this what I was requested to do :)
Photo of Ary Velstra, Expert Trainer

Ary Velstra, Expert Trainer

  • 1885 Posts
  • 337 Reply Likes
Again, educate your client.
His request shows he has little or no experience in projectmanagement.
Ask him why he wants it. Show him that a gantt chart gives him better info.
Suggest he takes a projectmanagement class.
Photo of Andrey Kazak

Andrey Kazak

  • 247 Posts
  • 21 Reply Likes
Got it.
However, this is a requirement in tender documentation :)
I think the client wants to find the calendar end date of the project.
Photo of Ary Velstra, Expert Trainer

Ary Velstra, Expert Trainer

  • 1885 Posts
  • 337 Reply Likes
Even in a tender you can explain how you provide better info using Gantt.
I have never lost a tender on such a silly request after I explained how it  could be done better.
And if they persist, be happy you don't get that client.
They will cause you lots of lost money and even bankruptcy.
Photo of Nick Duffill

Nick Duffill, Champion

  • 605 Posts
  • 248 Reply Likes
If you structure the project as a WBS, and enable Task Rollup at the top of the tree, then the Task Info will show the end date of the project on that topic.
Photo of Alex Gooding

Alex Gooding, Champion

  • 1274 Posts
  • 354 Reply Likes
The Task Info on the rolled up task that Nick describes also shows the duration in workdays. If you still need a rough idea of the total number of calendar days a project will involve you can set up a formula to divide this figure by 5 and multiply by 7. The result would be written to a topic property on the rolled up topic.

Obviously this calculation doesn't take into account public holidays. It wouldn't be accurate for individual tasks or small projects which are less than a week in duration, but it would give you a reasonable total estimate for larger projects.

Ultimately however it would be great if MM provided a facility to allow task start and due dates to be shown in topic properties as Excel-style date numbers and referenced in formulas, along with other dates. The ability to do date arithmetic would be useful for a number of purposes other than just showing the total number of calendar days involved in a project.
(Edited)
Photo of Andrey Kazak

Andrey Kazak

  • 247 Posts
  • 21 Reply Likes
I fully support you!
Photo of Andreas Lercher

Andreas Lercher

  • 122 Posts
  • 53 Reply Likes
Usually public holidays or not excluded in a project.
Is this different in other parts of the world?
Photo of Alex Gooding

Alex Gooding, Champion

  • 1274 Posts
  • 354 Reply Likes
If they are added under calendar options then public holidays are obviously excluded from MM's calculation of project duration. Unfortunately my simple formula can't account for this in calculating calendar days, as it assumes every work week has a standard number of five work days.

This reminds me that I forgot to mention that the formula has to be adjusted if there is a different number of work days, for example, if the organisation works only a four-day-week.
Photo of Andreas Lercher

Andreas Lercher

  • 122 Posts
  • 53 Reply Likes
4-days ist possible. Deactivate a day in the task calendar.

Is you export the task list to excel you can exclude public holidays from the calculation. I did this for a special client's project
Photo of Alex Gooding

Alex Gooding, Champion

  • 1274 Posts
  • 354 Reply Likes
Agreed, but my point was that if you adjust the MM calendar then you have to change my simple formula for counting calendar days from [CalendarDays]=Duration/5x7 to [CalendarDays]=Duration/4x7.