How do I convert GMT to local time?

I am using Excel 2003.  I have a column containing GMT (London time).  How can I convert it to local time which is GMT minus 5 hours?

 

Thank you for any assistance.

 
Question Info

Last updated June 29, 2018 Views 76,504 Applies to:
Answer

Hi,

Subtract 5 hours

=A1-TIME(5,0,0)


If this post answers your question, please mark it as the Answer.
Mike H
If this response answers your question then please mark as answer.

Mike H

12 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Answer

Try

=A1-5/24

 

 


If this answer solves your problem, please check, Mark as Answered. If this answer helps, please click the Vote as Helpful button. Cheers Shane Devenshire
Shane Devenshire

11 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.