Hello Folks,
I have attached an example workbook of data.
Sheet 1, Planner (in this sheet different time zones are displayed) STATE TIME has to be displayed in sheet2,
Sheet 2, Client (in this sheet, client data)
What I need is to show the TIME in column G of sheet2 according to the CLIENT STATE (which is a bill to state).
If a client is in WA, United States, time should be displayed in the time zone column as per WA state. while keeping in mind that there are many client in the same state.
Bookmarks