I am trying to add a calculated field on a time interval (by 30 minutes, string type) to adjust for different time zones based on the client market segments. Is this possible? Or do you have any other suggestions to do to make this work!
So far this is what I have:
IF ([LocalTime_Client] "AET" AND [Local_Standard_Time] "AUS Standard Eastern Time", THEN [CST_Interval] = [Local_Interval] -14 ) OR..... etc
Any sample workbook and screenshot showing your expected result?