I cannot get the formula to work. It seems the formula gets confused because
there is a date value as well as a time value. I tried the following formula
and it gave me the following result:

Formula
=(+TIME(5,0,0))

If I try to use =G2-TIME(5,0,0) it gives me a circular reference.


Result
01/00/1900 5:00:00 AM

instead of what I would like to see for G2 which is
01/08/2009 8:40:46 AM
instead of
01/08/2009 1:40:46 AM

Regards,

"Mike H" wrote:

Ken

with your date/time in a1 use

=A1-TIME(5,0,0)

Mike

"Ken" wrote:

I'm working with the following date column in my excel document but it is in
GMT. I need a formula to subtract 5hrs from the time stamp in Column "G" in
order to convert it to EST.

G
CLOSE_DATE
01/08/2009 1:40:46 AM
01/08/2009 2:32:55 AM
01/08/2009 5:40:33 AM
01/08/2009 5:47:32 AM
01/08/2009 5:49:58 AM
01/08/2009 6:30:43 AM
01/08/2009 10:43:55 AM

Any help would be greatly appreciated.