This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
A solution to last week’s challenge can be found here.
To solve this week’s challenge, use Designer Desktop, Designer Cloud Trifacta Classic or Designer Cloud, Designer Experience.
Imagine you work for an international company and have colleagues in locations around the world. You need an easy way to remember how many hours ahead or behind the time is at their location. Using a time zone table from Wikipedia and a list of cities where your coworkers live, you want to produce a list of the time differences between city pairs.
Using the dataset and the table provided, complete the following task:
Determine the time difference between each pair of cities in your output. Each city pair should be listed twice, with the correct time difference either ahead or behind. Your output should look like this.
ATTENTION Designer Cloud Developers: The solution in Designer Desktop looks like this:
Had to figure out that the symbol representing negative was "−" and not "-".