software

I need to change Zulu time back 1 hour due to the daylight savings time.
I have a format I need to follow, which is example  04:45Z? Where
the P needs to remain because it signifies proposed, and the Z needs to
remain, because it signifies Zulu and the time 04:45 needs to be made
03:45 while preserving the P and the Z, so therefore,  04:45Z? needs
to be  03:45Z?. I need this as a formula, because there are a lot of
time changes to be made. Can anyone help with this formula?--
Cactus-747
------------------------------------------------------------------------
Cactus-747's Profile: www.excelforum.com/member.php...oamp;userid=33172
View this thread: www.excelforum.com/showthread...hreadid=529948quot;Pquot; h:mmquot;Zquot;
Suppose your original time value is in cell A2, then enter this formula in
an unused column
=A2-TIME(1,0,0)

format it like the original cell quot;Pquot; h:mmquot;Zquot;
and fill it down as necessary!

Regards,
Stefi

?actus-747??ezt ?rta:

gt;
gt; I need to change Zulu time back 1 hour due to the daylight savings time.
gt; I have a format I need to follow, which is example ? 04:45Z?? Where
gt; the P needs to remain because it signifies proposed, and the Z needs to
gt; remain, because it signifies Zulu and the time 04:45 needs to be made
gt; 03:45 while preserving the P and the Z, so therefore, ? 04:45Z?? needs
gt; to be ? 03:45Z??. I need this as a formula, because there are a lot of
gt; time changes to be made. Can anyone help with this formula?
gt;
gt;
gt; --
gt; Cactus-747
gt; ------------------------------------------------------------------------
gt; Cactus-747's Profile: www.excelforum.com/member.php...oamp;userid=33172
gt; View this thread: www.excelforum.com/showthread...hreadid=529948
gt;
gt;