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.

Answer
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

16 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

Answer
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

15 people were helped by this reply

·

Did this solve your problem?

Sorry this didn't help.

Great! Thanks for marking this as the answer.

How satisfied are you with this reply?

Thanks for your feedback, it helps us improve the site.

How satisfied are you with this response?

Thanks for your feedback.

 
 

Question Info


Last updated September 23, 2020 Views 80,590 Applies to: