+ Reply to Thread
Results 1 to 11 of 11

World Time Converter

  1. 06-18-2009, 10:12 PM #1
    kmcpani
    kmcpani is offline
    Registered User
    Join Date
    03-29-2008
    Posts
    8

    World Time Converter

    Dear all,

    I got world time converter from Internet. This is for caculating time difference in different countries.

    In that, only some countries are available and i want to add more. Can any one solve this issue and also advise me the logic behind this. I am attaching the file here.

    I am eagerly waiting for the reply.

    Thanks & Regards

    Chakrapani
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 06-18-2009, 11:37 PM #2
    shg
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: World Time Converter

    See, for example, http://www.tushar-mehta.com/excel/timezone.htm.

    For others, Google excel time zones
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  3. 06-19-2009, 04:59 AM #3
    kmcpani
    kmcpani is offline
    Registered User
    Join Date
    03-29-2008
    Posts
    8

    Re: World Time Converter

    Thanks a lot
    Reply With QuoteRegister To Reply
  4. 06-19-2009, 06:00 AM #4
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: World Time Converter

    apart from the fact its locked,hidden,protected etc. why not email the author and ask him/her?
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula
    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC
    Reply With QuoteRegister To Reply
  5. 06-19-2009, 07:40 AM #5
    kmcpani
    kmcpani is offline
    Registered User
    Join Date
    03-29-2008
    Posts
    8

    Re: World Time Converter

    I contacted him through email but no response from him
    Reply With QuoteRegister To Reply
  6. 06-19-2009, 07:53 AM #6
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: World Time Converter

    well cant help you coz to open that we'd have to break into it. and that is against forum rules
    Reply With QuoteRegister To Reply
  7. 06-22-2009, 04:38 AM #7
    kmcpani
    kmcpani is offline
    Registered User
    Join Date
    03-29-2008
    Posts
    8

    Re: World Time Converter

    Ok. No Problem.

    Is there any possibility to explain the formule behind this and how can he got the solution.

    If my question is within rules then explain me otherwise ignore it.

    Thanks for your prompt response in the matter.
    Reply With QuoteRegister To Reply
  8. 06-22-2009, 04:51 AM #8
    squiggler47
    squiggler47 is offline
    Valued Forum Contributor squiggler47's Avatar
    Join Date
    02-17-2009
    Location
    Littleborough, UK
    MS-Off Ver
    Excel 3.0 to 2007+2010! (couldnt get 2.1 working)
    Posts
    1,013

    Re: World Time Converter

    It would be fairly easy to duplicate a similar sheet, all it would really require is a table of offsets from GMT or UTC.

    It all depends on what information you needed to get from the sheet!
    Regards
    Darren

    Update 12-Nov-2010 Still job hunting!

    If you are happy with the results, please add to our reputation by clicking the blue scales icon in the blue bar of the post.

    Learn something new each day, Embrace change do not fear it, evolve and do not become extinct!

    Reply With QuoteRegister To Reply
  9. 06-22-2009, 05:20 AM #9
    squiggler47
    squiggler47 is offline
    Valued Forum Contributor squiggler47's Avatar
    Join Date
    02-17-2009
    Location
    Littleborough, UK
    MS-Off Ver
    Excel 3.0 to 2007+2010! (couldnt get 2.1 working)
    Posts
    1,013

    Re: World Time Converter

    Here is a simple version, note it doesnt take into account Daylight Savings!

    (PS after looking neither does the origninal!)
    Attached Files Attached Files
    Last edited by squiggler47; 06-22-2009 at 08:36 AM. Reason: Re attaching sheet!
    Reply With QuoteRegister To Reply
  10. 06-22-2009, 08:33 AM #10
    martindwilson
    martindwilson is offline
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: World Time Converter

    it doesnt take into account there's no sheet attached either
    Reply With QuoteRegister To Reply
  11. 06-23-2009, 08:03 AM #11
    kmcpani
    kmcpani is offline
    Registered User
    Join Date
    03-29-2008
    Posts
    8

    Re: World Time Converter

    Thanks a lot squiggler47
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1