Hi all, I do hope someone can figure this out.
I have created a table that has time zone differences in it. I can then apply the place and time difference from GMT to a person.
This means I have a time zone allocated to a single person.
I then want to do a calc that shows how many hours they are behind or forward of me at any given time I decide
So for instance if I make a calender entry to call them back at 12:52 GMT, and the local time with the user I want to call back is -11 hours it should show 02:52
I have worked out how I can do the calc if I input an actual number - like in this calc
DATEADD({Contact Again GMT},-11,‘hours’)
This works and shows the correct local time.
However when i try to pull the number direct using this calc it’s wrong
DATEADD({Contact Again GMT},{Hours Difference (from Time Zone) (from People)},‘hours’)
It returns the result 13:52 instead … it doesn’t make any sense to me at all.
Any help would be really useful.
