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...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top