Zulu times

[Cactus-747]

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?

[Stefi]

"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
>
>