How to add two timezones in my plan?

[Pradeep sv]

My requirement is to display 2 timezones in my plan
Start and Finish date (Column b,c) - IST
Start1 and Finish1 date (Column d,e) - EDT

 

[Rob Schneider]

My requirement is to display 2 timezones in my plan
Start and Finish date (Column b,c) - IST
Start1 and Finish1 date (Column d,e) - EDT

Did you try using the custom fields and make them formulae per your
algorithm above? If yes, what was the result?

 

[Pradeep sv]

Trying custom field option ...will let you know if this helps me..

 

[Pradeep sv]

I used the following formulae
ProjDateSub([Start],480) to subtract 8 hours. It works fine.
My requirement is to subtract 9.5 hours..if i replace 480by 570 it give me
wrong result

 

[Mike Glen]

What result does it give you?

Mike Glen
Project MVP
See http://tinyurl.com/2xbhc for my free Project Tutorials

I used the following formulae
ProjDateSub([Start],480) to subtract 8 hours. It works fine.
My requirement is to subtract 9.5 hours..if i replace 480by 570 it give me
wrong result

Did you try using the custom fields and make them formulae per your
algorithm above? If yes, what was the result?

 

[Rob Schneider]

I used the following formulae
ProjDateSub([Start],480) to subtract 8 hours. It works fine.
My requirement is to subtract 9.5 hours..if i replace 480by 570 it give me
wrong result

Did you try using the custom fields and make them formulae per your
algorithm above? If yes, what was the result?

Pradeep,
I don't have time right now to work this out for you, but:
1. What was the result? How is it wrong? What is wrong?
2. Look at the documentation about this function. It mentions that it
uses projec calendars. Perhaps is the result it gives related to days as
defined in the calendar, so that when you go more than 8 hours it jumps
to a new day? I don't know; just a hunch that I would (but can't now)
research.
3. if No. 2 above is true, then find another function that does time
computations regardless of calendar. At first glance I did not find
that in the Project documentation.
4. Failing No. 3, then I'd write my own function which would be
notionally called TimeZoneAdd(Date_Time_TZ1, Minutes). Convert the
Date_Time_TZ1 into text and extract the Day, Month, Year, HH, MM, and SS
times as text. Add the number of Minutes using time arithmetic
(-negative number for timezones west), and then convert the result back
into a real date/time variable.

 

[Pradeep sv]

Hi Rob,

Thanks for the reply, here are the results ...

(1) ProjDateSub([Start],480)
Thu 06/04/09 8:00 AM - Column Start
Wed 06/03/09 8:00 AM - Derived date based on the forumala

The result obtained above is as expected

(2) ProjDateSub([Start],190)
Thu 06/04/09 8:00 AM - Column Start
Wed 06/03/09 1:50 PM - Derived date based on the forumala

Tried with the value 190 for (9.5 hours), but it dosen't work...i will try
other option that you suggested...

I used the following formulae
ProjDateSub([Start],480) to subtract 8 hours. It works fine.
My requirement is to subtract 9.5 hours..if i replace 480by 570 it give me
wrong result

Pradeep sv wrote:
My requirement is to display 2 timezones in my plan
Start and Finish date (Column b,c) - IST
Start1 and Finish1 date (Column d,e) - EDT
Did you try using the custom fields and make them formulae per your
algorithm above? If yes, what was the result?

Pradeep,
I don't have time right now to work this out for you, but:
1. What was the result? How is it wrong? What is wrong?
2. Look at the documentation about this function. It mentions that it
uses projec calendars. Perhaps is the result it gives related to days as
defined in the calendar, so that when you go more than 8 hours it jumps
to a new day? I don't know; just a hunch that I would (but can't now)
research.
3. if No. 2 above is true, then find another function that does time
computations regardless of calendar. At first glance I did not find
that in the Project documentation.
4. Failing No. 3, then I'd write my own function which would be
notionally called TimeZoneAdd(Date_Time_TZ1, Minutes). Convert the
Date_Time_TZ1 into text and extract the Day, Month, Year, HH, MM, and SS
times as text. Add the number of Minutes using time arithmetic
(-negative number for timezones west), and then convert the result back
into a real date/time variable.

 

[Pradeep sv]

It worked!

ProjDateSub([Start],570,"prad-cal")

570 = To subtract 9.5 hours
prad-cal = Have defined a 24 hour calendar
Also have set 24 hour calendar for the project

Thank you all for your assistance

Hi Rob,

Thanks for the reply, here are the results ...

(1) ProjDateSub([Start],480)
Thu 06/04/09 8:00 AM - Column Start
Wed 06/03/09 8:00 AM - Derived date based on the forumala

The result obtained above is as expected

(2) ProjDateSub([Start],190)
Thu 06/04/09 8:00 AM - Column Start
Wed 06/03/09 1:50 PM - Derived date based on the forumala

Tried with the value 190 for (9.5 hours), but it dosen't work...i will try
other option that you suggested...

I used the following formulae
ProjDateSub([Start],480) to subtract 8 hours. It works fine.
My requirement is to subtract 9.5 hours..if i replace 480by 570 it give me
wrong result
:

Pradeep sv wrote:
My requirement is to display 2 timezones in my plan
Start and Finish date (Column b,c) - IST
Start1 and Finish1 date (Column d,e) - EDT
Did you try using the custom fields and make them formulae per your
algorithm above? If yes, what was the result?

Pradeep,
I don't have time right now to work this out for you, but:
1. What was the result? How is it wrong? What is wrong?
2. Look at the documentation about this function. It mentions that it
uses projec calendars. Perhaps is the result it gives related to days as
defined in the calendar, so that when you go more than 8 hours it jumps
to a new day? I don't know; just a hunch that I would (but can't now)
research.
3. if No. 2 above is true, then find another function that does time
computations regardless of calendar. At first glance I did not find
that in the Project documentation.
4. Failing No. 3, then I'd write my own function which would be
notionally called TimeZoneAdd(Date_Time_TZ1, Minutes). Convert the
Date_Time_TZ1 into text and extract the Day, Month, Year, HH, MM, and SS
times as text. Add the number of Minutes using time arithmetic
(-negative number for timezones west), and then convert the result back
into a real date/time variable.

 

[Steve House]

For subtracting 190 working time minutes, your 13:50 derived start time is
correct. Your Project calendar must be showing an 8am to 5pm calendar.
I'll bet you changed the calendar page "hours per day" setting to 9.5 but
didn't change the actual working time calendar to show the actual start and
end hours for the workday. Note that the "hours per day," "hours per week,"
and "day per month" option settings are conversion factors for duration
entry and changing them DOES NOT change anything on the actual work
calendar. 1700 Wednesday and 0800 Thursday coincide, they are the same
minute. Subtracting 190 minutes from 17:00 gives you 13:50.
--
Steve House
MS Project Trainer & Consultant

Hi Rob,

Thanks for the reply, here are the results ...

(1) ProjDateSub([Start],480)
Thu 06/04/09 8:00 AM - Column Start
Wed 06/03/09 8:00 AM - Derived date based on the forumala

The result obtained above is as expected

(2) ProjDateSub([Start],190)
Thu 06/04/09 8:00 AM - Column Start
Wed 06/03/09 1:50 PM - Derived date based on the forumala

Tried with the value 190 for (9.5 hours), but it dosen't work...i will try
other option that you suggested...

I used the following formulae
ProjDateSub([Start],480) to subtract 8 hours. It works fine.
My requirement is to subtract 9.5 hours..if i replace 480by 570 it give
me
wrong result
:

Pradeep sv wrote:
My requirement is to display 2 timezones in my plan
Start and Finish date (Column b,c) - IST
Start1 and Finish1 date (Column d,e) - EDT
Did you try using the custom fields and make them formulae per your
algorithm above? If yes, what was the result?

Pradeep,
I don't have time right now to work this out for you, but:
1. What was the result? How is it wrong? What is wrong?
2. Look at the documentation about this function. It mentions that it
uses projec calendars. Perhaps is the result it gives related to days as
defined in the calendar, so that when you go more than 8 hours it jumps
to a new day? I don't know; just a hunch that I would (but can't now)
research.
3. if No. 2 above is true, then find another function that does time
computations regardless of calendar. At first glance I did not find
that in the Project documentation.
4. Failing No. 3, then I'd write my own function which would be
notionally called TimeZoneAdd(Date_Time_TZ1, Minutes). Convert the
Date_Time_TZ1 into text and extract the Day, Month, Year, HH, MM, and SS
times as text. Add the number of Minutes using time arithmetic
(-negative number for timezones west), and then convert the result back
into a real date/time variable.