🕑 Time-Zone Tracking
This template is intended for those seeking a time-zone calculator for remote workers that can showcase what time workers are available in relation to location. In addition, if a client's workday is between 8am and 6pm in the U.K, this table will return whether or not the client is available.
How it works → Insert Location, Name and Hour Discrepancy.
In the example provided by the template, every international worker between a ...
1 to 6 hour discrepancy start work at 11am and end work at 7pm (in their time zone).
7+ hour discrepancy start work at 1pm and end work at 9pm (in their time zone).
Otherwise, start work at 6am and end work at 1pm (in their time zone)
Customize :: Plug in different limitations inside Available property ⤵
if(prop("Hour Discrepancy") <= 6 and hour(prop("Their Time")) > 11 and hour(prop("Their Time")) < 19, true, if(prop("Hour Discrepancy") > 7 and hour(prop("Their Time")) > 13 and hour(prop("Their Time")) < 21, true, if(prop("Hour Discrepancy") < 0 and hour(prop("Their Time")) > 6 and hour(prop("Their Time")) < 13, true, false)))