For example, if daylight saving time in your time zone is one hour ahead of standard time, add one hour to the offset-adjusted time.
.
Instead, an efficient solution will be to do it while importing the data using the function DateTimeZone.
The time setting when adjusted for offset is 06:00 6:00 A.
After Kutools for Excel, please do as below: 1.
LocalNow has the expected same effect.