Time Zone Conversion (1 Viewer)

I have a dataset that collects downtime minutes of internet service by an internet provider. This provider is on the U.S. East coast EST and has customers in England, India and Hong Kong.

I need to create some type of query, calculated field, filter or parameter that allows the user after filtering to show events for their country to determine if the downtime event happened before or after their business hours, for example, 08:00 AM and 17:00 PM in the customer's time zone.

Thank you for your help!

This seems to have been overlooked. Have you fixed your problem since?

If not, you need a table listing all time zones and locations (at least for the areas you do business with). You should have fields listing time zone e.g GMT-5, business start hours, business end hours for each business plus event downtime and it would help to have a Boolean field to indicate whether during work hours (though a query could just calculate that if preferred)

HTH
If you have questions, get back to us and if necessary upload some example data so someone can help you with the query