Handling

Multiple Hours-Per-Days

by Using Custom Field Formulas

in Microsoft® Office Project

by Ismet Kocaman

An eBook for the users of all desktop editions/versions

 

Released in June 2022

 

Available to purchase in multiple formats

Download & read on your computer or reader

 

 

 

 

What is in the eBook ?

 

In this eBook, we will develop some custom elements to help MS Project users who want to apply non-default hours-per-day conversion factors and start/end times to the tasks scheduled according to the task calendars in the same project plan file.

 

Background Information and More on the eBook's Content

 

While building a project schedule in MS Project, most probably, it will be required to edit the default working/nonworking time patterns defined in the base calendar selected as the project calendar in order to customize them for the project being currently planned; or instead of using a modified base calendar, a new base calendar with the custom patterns can be created to be used as the project calendar. And then, if required, the project’s time unit conversion factors associated with the three time periods (i.e., Hours per day, Hours per week, and Days per month ) and the default start/end times (i.e., Default start time and Default end time) are set according to the project calendar. Synchronization among all these settings ensures consistency in the project schedule’s data either calculated/filled in by MS Project or entered by the user. 

 

The project calendar is the global calendar which applies to the whole project, and it cannot be customized for individual tasks or group of tasks. At this point, MS Project’s calendar feature enables us to define and apply task calendars to the tasks that need to be scheduled with the working/nonworking times different than the rest of the project in the same project plan file. For example, some tasks of a single location project or tasks at certain sites of a multi-location project may require the use of task calendars with different working/nonworking times in the same schedule. However, in such projects, the resulting data that the project schedule show may cause confusion if the user is not aware of MS Project’s behavior in that both the time unit conversion factors and the default start/end times, which are adjusted according to the project calendar, are also applied to the tasks with task calendars since it is not possible to set separate versions of these two groups of settings for each task calendar. This situation immediately leads to the following question, which will be answered in this eBook: how to deal with this behavior while scheduling such projects in MS Project ?

 

Who should read ?

 

The content has been aimed at professionals who currently plan and manage projects by using MS Project, and therefore, who already have knowledge and skills to handle various calendars, and also to develop and maintain custom field formulas in MS Project, and at the same time, who want to learn techniques on how to handle multiple calendars with non-default start/end times in MS Project. It is important to note that the model presented here is not a complete solution to the issue but rather a limited workaround for small projects in a single project plan file with no subprojects (i.e., inserted projects) and involves adjustments for the hours-per-day values only. On the other hand, it can be customized to implement in many project management scenarios.

 

Details on the eBook

 

All the information presented in this eBook are based on the results of experimenting with the latest standalone desktop version of MS Project available at the time of writing this eBook. The examples in this eBook were developed and tested by using MS Project loaded with the latest updates. The eBook contains 44 pages. There is no printed version of this eBook. The mpp files for the eBook are not available to purchase. 

 

The details on the electronic book format of the eBook are as follows:

 

  • Page size of the eBook is 8.5 x 11 inches (the paper size Letter).  

  • eBook is in pdf format (see the details on the Kindle edition of the eBook here). Click here to see the list of errata.

  • eBook can be viewed by any pdf viewer.

 

 

 

 

BONUS Material for the PDF eBook

 

The mpp file used in demonstrations is presented as a bonus (that is, not a supplement as part of the purchase) for the pdf eBook. Download link will be provided within the email message that you will receive after the purchase.

 

 

 

 

 

How to Buy the eBook in PDF format

Important Note to Purchasers - All sales are final. The purchase of this eBook is not refundable and no returns are accepted for this eBook. Therefore, review the details explained above and the sample content here on your computer system thoroughly and make sure that both the content and the format suit your needs before attempting to buy the eBook.

 

Click the ordering button below if you want to purchase the eBook in pdf format (Price: US$29.99). You will receive an email with the download link as soon as you complete your purchase.

 

 

All transactions will take place through FastSpring's system (a BBB A+ accredited business in US) and the eBook file will be directly delivered from FastSpring's servers

 

 

 

Copyright © All Content - Ismet Kocaman | http://www.ismetkocaman.com

 

Microsoft® is a registered trademark or trademark of Microsoft Corporation in the United States and/or other countries. The author of this document has no affiliation with Microsoft Corporation. All other trademarks mentioned herein are the property of their respective owners.