(HOUR(gmt)-HOUR(ldt))
+ (24 * (ABS((YEAR(gmt)*10000+MONTH(gmt)*100+DAY(gmt))
-(YEAR(ldt)*10000+MONTH(ldt)*100+DAY(ldt)))
/ ((YEAR(gmt)*10000+MONTH(gmt)*100+DAY(gmt))
-(YEAR(ldt)*10000+MONTH(ldt)*100+DAY(ldt)))
))
+ (MINUTE(gmt)-MINUTE(ldt))/60
To use it, 3 columns are required:
Now special value to obtain the Users current local time. This is used as ldt in the formula.GMT suffix. This is used as gmt in the formula.The result should be a number, which represents the difference in hours between the users local time and UTC.
