Unit count for Duration

Sirius_200

In the Duration column, instead of "d" for days, is there a way to show "wks" (for weeks) or "mons" (for months)?

Genevieve P.

Hi @Sirius_200

The Duration column can be filled out with the following formats:

• Weeks (2w)
• Whole working days (4d)
• Partial working days (3.5d)
• Hours (7h)
• Minutes (60m)
• Seconds (500s) and milliseconds (50000ms)
• A combination of hours, minutes, seconds, and milliseconds (4h 30m)
• Elapsed time (lead with an e) indicates elapsed time duration (e3d, e5h, e3.5d, etc.). A task with a duration in elapsed time ignores non-working time. The task will start and end in the amount of time specified regardless of working day length and non-working days in the sheet.

Here's the article with more information: Project Sheet Columns: Start Date, End Date, Duration, % Complete and Predecessors

Cheers!

Genevieve