"P" h:mm"Z"
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 "P" h:mm"Z"
and fill it down as necessary!
Regards,
Stefi
€žCactus-747€ ezt Ã*rta:
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 €œP 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, €œP 04:45Z€ needs
to be €œP 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: http://www.excelforum.com/member.php...o&userid=33172
View this thread: http://www.excelforum.com/showthread...hreadid=529948