+ Reply to Thread
Results 1 to 8 of 8

Converting Time Values from One Time Zone to Another

  1. #1
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Converting Time Values from One Time Zone to Another

    Hi Excelians!

    * Need a normal date calculation according to selected time zone.
    * Formula required in [D7], facing problem in Negative TimeValue.

    Please find the attached for detail.
    Last edited by Debraj Roy; 09-04-2013 at 01:12 AM.
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  2. #2
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Converting Time Values from One Time Zone to Another

    BTW..
    You can Skip...
    * Date calculation &
    * Duplicate Abbr..

  3. #3
    Forum Contributor
    Join Date
    08-14-2013
    Location
    Here and there
    MS-Off Ver
    Excel 2010
    Posts
    376

    Re: Converting Time Values from One Time Zone to Another

    The attached spreadsheet was put up in response to another thread about date, time and time zones. May not be what you are looking for but have a look.

    DATE & TIME.xlsx

  4. #4
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Converting Time Values from One Time Zone to Another

    Hi ursul..

    Thanks for you prompt reply.. and hats off to your guess..
    yes.. Its not the same what I am looking for..

  5. #5
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Converting Time Values from One Time Zone to Another

    Can someone please look into this..

  6. #6
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Converting Time Values from One Time Zone to Another

    In D7

    =D3-VLOOKUP(F5,TimeZone,5,0)+VLOOKUP(C5,TimeZone,5,0)+(VLOOKUP(F5,TimeZone,5,0)>VLOOKUP(C5,TimeZone,5,0))
    Life's a spreadsheet, Excel!
    Say thanks, Click *

  7. #7
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Converting Time Values from One Time Zone to Another

    Hi Ace_XL..

    will confirm and update you within few minute.. Thanks is advance..

  8. #8
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Converting Time Values from One Time Zone to Another

    WOW.. your binary logic works.. Thanks for the help..

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Date and time conversion to another time zone
    By RUBEN PARRAS in forum Excel General
    Replies: 1
    Last Post: 05-21-2012, 09:03 PM
  2. Converting Time Zone
    By prodigy06 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-13-2011, 12:22 AM
  3. Macro for converting Time Zone
    By humacdeep in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 09-21-2011, 06:05 PM
  4. How can i find time in various time zone?
    By priya_yuvaraj in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 11-11-2005, 03:50 AM
  5. Converting Time Values from One Time Zone to Another
    By ExcelTip in forum Tips and Tutorials
    Replies: 0
    Last Post: 08-23-2005, 12:12 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1