To prevent time zone issues in xl360 templates, which can result in incorrect display of start and end dates in the WBS, Effort Allocation, and Fee Estimator spreadsheets, as well as improper distribution of efforts in the Effort Allocation spreadsheet. It is recommended that the working hours time zone for Bookable Resources align with the time zones specified in their respective Bookable Resource form.
- This configuration will ensure accurate date calculations in xl360 spreadsheets, as mismatched time zone settings currently cause dates to shift incorrectly.
- Additionally, aligning time zones will allow for correct distribution of efforts from the WBS, ensuring that efforts allocated within each time frame are accurately represented.
Bookable Resource time zone
Working hours time zone
