Hello,

I'm trying to create a formula using only select values of a cell.

For example cell G1 has the following data:

12/Nov/2009 1620ZULU

I'd like to create a formula which deducts five hours from the zulu time.
Essentially I'd like the cell to read:

12/Nov/2009 1120EST

Please help! Thanks in advance.