time zones

  1. P

    Multi timezone calculator

    Hello, This is my first forum post on the Internet. I guess I should start with defining the manual process that I think Excel can automate. There are offices in multiple cities, all working 9am to 6pm in their respective time zones. There are processes that are run at the Head Office that...
  2. M

    Convert between Local Time and UTC Time

    Hello Excel experts, I want to convert between the time in my timezone and UTC time by using some functions. I don't need a date part, but only need a time. Through some research on the internet, I found and modified codes that works, but with some errors. 1. For function "ConvertLocalToGMT"...
  3. T

    Creating SLA report - need help w/ accounting for working hours and time zones

    I am trying to create an SLA (service level agreement) report. I have data that supports a date/time that something was requested and a date/time of completion all associated with 1 time zone. I need to be able to calculate the number of minutes between request to completion. Then take that...
  4. S

    Time Zone Detection?

    Is there any Excel formula or VBA function that can detect the time zone to which the user's system is set? I'm working on a function which calculates a schedule for a certain facility, which will be distributed to users in multiple time zones. I could just have the user select his or her own...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top