time zone

  1. S

    Combo Box Time Zone Format Values

    Hi All, I've the below code but it doesn't seem to convert the 0 to show UTC however the second to last line where the numbers are formatted works for all possitive and negatives but not for 0. Format(ComboBox1.List(i), "+h:mm;-h:mm; ""UTC"" ") I've tried all sorts of combinations, many...
  2. A

    Date Format - Time Zone issue?

    I received an excel file from a coworker in Texas, while I reside on the east coast. I thought nothing of it, until i was putting a series of dates in to it from another spreadsheet i had created previously. I realized that instead of the date displaying as "DD/MM/YY" in the excel file I was...
  3. well2ant

    VBA to apply custom NumberFormat for date/time time zone

    Hello all, I apologise if this is a duplicate - I tried to post it earlier but couldn't see it anywhere. I have written a module to convert date & times provided in UTC time into a different local time zone. The coding works well and automatically takes into account nay daylight saving time...
  4. P

    CMS coding in VBA

    Hello, Is there coding to allow you to change the default time zone in CMS when pulling data through VBA? Thanks
  5. B

    identify time zone by looking at area code

    I have a column full of phone numbers. I would like to be able to denote what time zone each number is in, in a separate column for each corresponding row. How can I do this? I would imagine the formula would look at the first 3 digits for each number and then be able to identify what time...

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
Back
Top