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