User Profile
abo999
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Re: Displaying multiple timezones for tasks
John-project Thanks for this. We're all on Project 2016 though there *may* be a slight difference in version due to regional licencing? I've made a quick test project with the formula you suggested and asked my colleagues to test it. Will see what happens!2.7KViews0likes4CommentsDisplaying multiple timezones for tasks
Here is my scenario: I'm lead PM with a team working on systems maintenance over the course of a given weekend. The maintenance will run 24 hours/day over the weekend, and involves work in both NA and EMEA. I'm also supported by two other PMs to maintain constant PM coverage over the full period. I'm based in EMEA, the start/finish times are planned in MST (GMT-7h) Because the team is split over two regions, to make it easy on the folks doing the tasks I wanted to show the start/finish times in both MST and GMT. This was fairly easy with a formula in a custom field: [Start]+[Number10]/24 where the Number10 field contains the 7 hour timezone offset However... When I hand off to another PM based in the US, the formula breaks (returns #Error) and I'm assuming this is to do with where we are all located? Is there a better way to do this? I'm not wanting to do anything trick with the different timezone columns; all the updates, calculations etc. will be done with [Start] and [Finish] fields, I just want to add a couple of extra columns to show the date and time in GMT.Solved2.8KViews0likes6Comments
Recent Blog Articles
No content to show