Help

Airtable | Everyone's app platform

Topic Labels: Dates & Timezones
659 1
cancel
Showing results for 
Search instead for 
Did you mean: 
D_Rourke
4 - Data Explorer
4 - Data Explorer

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.

1 Reply 1

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