Date reformatting question
Hi,
Am Mon, 5 Nov 2012 18:13:37 +0000 schrieb DateNightma
2012-11-02 16:02:19 Etc/GMT
The problem is that I need these times to be in Pacific Time, not GMT.
your date and time in A1:
=LEFT(A1,19)-TIME(8,,)
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
|