How do I convert GMT date/time to different timezone

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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).
 
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
 
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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

GMT timezone 7
Special string convertion to date and time 4
date/time calculation 3
convert GMT Date & Time 6
Convert QuickBooks time format to excel to calculate 2
How do I set up an Excel workbook to convert GMT to EST? 4
Timezone converter 1
Converting text format of time/date into Excel time/date for subtr 5

Back
Top