Excel - Convert local time to GMT

cpeters5
cpeters5 used Ask the Experts™
on
In cell A1, I have 1:10:20 GMT.  How do I convert it to local time (GMT - 5 hrs)?
Thanks,
pax
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Network Administrator
Commented:
Use the TIME function as shown in the following formula:
=A2-TIME(6,0,0)

You would have to know the time difference between your local time zone and GMT.
Top Expert 2010

Commented:
You would also have to have awareness of any Daylight Saving Time/Summer Time/etc. rules...

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial