How do I convert GMT date/time to different timezone

H

Hooves57

I am using a web-based software that reports the date and time a record was
captured. I can export these records to Excel. I would like to convert that
date/time to HK time (GMT+7). I have been able to convert the time, but not
the date (date frequently changes).
 
F

Franz Verga

Hooves57 said:
I am using a web-based software that reports the date and time a
record was captured. I can export these records to Excel. I would
like to convert that date/time to HK time (GMT+7). I have been able
to convert the time, but not the date (date frequently changes).
Click to expand...

Just add the hours this way:

A2+"7:00"

Where A2 is the time to convert. You can also insert the time to add for
conversion in another cell and than simply sum together...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
H

Hooves57

Thanks for your help. I appreciate it.

Franz Verga said:
Just add the hours this way:

A2+"7:00"

Where A2 is the time to convert. You can also insert the time to add for
conversion in another cell and than simply sum together...


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
Click to expand...
 
Top