If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Subtracting Time Zone for Universal Time and Date
I am trying to adjust a user inputted time, date and Time Zone to Universal
time. Date: C2 Local Time: C3 Time Zone: C4 But the problem is subtracting time. So if I have 02/01/2004 5:00:00 -6 I need my new date and time to read: 01/31/2004 23:00:00 And if the Zone is +20 then the new date would be: 02/02/004 1:00:00 I have a function that calls Year, Month, Date, Hours, Min, Sec to get the Julian Date. I tried combining the date and time into 1 cell "dd:mm:yy hh:mm:ss" and doing the math but I had no luck Is there an easy way to achieve this goal? Thanks |
#2
|
|||
|
|||
Subtracting Time Zone for Universal Time and Date
Pal,
It will require a macro, or some judicious circular references (not recommended in this situation) to actually change the date and time in C2 and C3 as a function of the time zone in C4. Better is to put the new date/time in a separate cell somewhe =C2+C3+C4/24 -- Earl Kiosterud mvpearl omitthisword at verizon period net ------------------------------------------- "Pal" wrote in message news:4JhTb.158713$sv6.875036@attbi_s52... I am trying to adjust a user inputted time, date and Time Zone to Universal time. Date: C2 Local Time: C3 Time Zone: C4 But the problem is subtracting time. So if I have 02/01/2004 5:00:00 -6 I need my new date and time to read: 01/31/2004 23:00:00 And if the Zone is +20 then the new date would be: 02/02/004 1:00:00 I have a function that calls Year, Month, Date, Hours, Min, Sec to get the Julian Date. I tried combining the date and time into 1 cell "dd:mm:yy hh:mm:ss" and doing the math but I had no luck Is there an easy way to achieve this goal? Thanks |
Thread Tools | |
Display Modes | |
|
|