| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I convert GMT date/time to different timezone
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). |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I convert GMT date/time to different timezone
Hooves57 wrote:
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). 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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I convert GMT date/time to different timezone
Thanks for your help. I appreciate it.
"Franz Verga" wrote: Hooves57 wrote: 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). 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to convert date/time to seconds | Excel Worksheet Functions | |||
| Convert date/time to text | Excel Discussion (Misc queries) | |||
| Convert Unix timestamp to Readable Date/time | Excel Worksheet Functions | |||
| Convert Date/Time to the Hour | Excel Discussion (Misc queries) | |||
| How do i convert a number of seconds to a date/time? | Excel Worksheet Functions | |||
Linear Mode
