Home » Category » Microsoft Excel

Microsoft Excel: Zulu times

205| Thu, 22 May 2008 18:45:00 GMT| anonymous| Comments (1)
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?action=getinfo&userid=33172
View this thread: http://www.excelforum.com/showthread.php?threadid=529948

Keywords & Tags: zulu, times, microsoft, excel

URL: http://www.developertags.com/microsoft-excel/495235/
 
«« Prev - 1 helpful answers below.
"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?action=getinfo&userid=33172
> View this thread: http://www.excelforum.com/showthread.php?threadid=529948
>

stefi | Thu, 22 May 2008 18:46:00 GMT |

Microsoft Excel Hot Answers

Microsoft Excel New questions

Microsoft Excel Related Categories