Airtable | Everyone's app platform

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.

My training video & sample base on time zones may help you:

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.