I am kind of novice in Excel and designing a spreadsheet for my employer. This is what i am trying to do. First, i am trying to figure out, how to automatically update time, based on specific city's time zone? Lets say, if the city is dallas, time zone is Central GMT-6. In the next cell, the time shows up as Dallas's local time, instead of local computer time. And this time updates itself after every 2 min.
2ndly, if that city's time is later than 8:59 PM local time, that specific city's cell grays out.
Any help will be highly appreciated. I am lost
Attach: Snapshot of sheet
Bookmarks