Results 1 to 8 of 8

Thread: Automatic Time Update as per Timezone

  1. #1
    Neophyte Silkaline's Avatar
    Join Date
    Aug 2017
    Location
    Kathmandu, Nepal
    Posts
    4
    Articles
    0
    Excel Version
    2010

    Automatic Time Update as per Timezone



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi,
    I need Help on making formula to automatic time update to different timezone. I have attached file. Any help would be greatly appreciated.

    Thank You.
    Attached Files Attached Files

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,471
    Articles
    0
    Excel Version
    Excel 2016
    Try:

    =B2+C2-TIME(5,75,)-TIME(4,,
    ) for EST
    =B2+C2-TIME(5,75,)-TIME(7,,) for PST


  3. #3
    Acolyte Sahil1390's Avatar
    Join Date
    Nov 2016
    Location
    India
    Posts
    58
    Articles
    0
    Excel Version
    2007
    Quote Originally Posted by NBVC View Post

    =B2+C2-TIME(5,75,)-TIME(4,,
    ) for EST
    Hi NBVC

    Can you please explain why you used B2 as its a date?

    Regards
    Sahil

  4. #4
    Neophyte Silkaline's Avatar
    Join Date
    Aug 2017
    Location
    Kathmandu, Nepal
    Posts
    4
    Articles
    0
    Excel Version
    2010
    Thank you very much for reply. I think something went wrong. When I used this formula EST and PST are not showing correct time. I have attached the updated one with this formula...
    Attached Files Attached Files

  5. #5
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,471
    Articles
    0
    Excel Version
    Excel 2016
    Sorry, my the MINUTE parameter in my formula should have been 45, not 75.

    =B2+C2-TIME(5,45,)-TIME(4,,) for EST
    =B2+C2-TIME(5,45,)-TIME(7,,) for PST


  6. #6
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,471
    Articles
    0
    Excel Version
    Excel 2016
    Quote Originally Posted by Sahil1390 View Post
    Hi NBVC

    Can you please explain why you used B2 as its a date?

    Regards
    Sahil
    Because I need to combine date and time to subtract an amount of time which could end up being previous day.


  7. #7
    Neophyte Silkaline's Avatar
    Join Date
    Aug 2017
    Location
    Kathmandu, Nepal
    Posts
    4
    Articles
    0
    Excel Version
    2010
    NBVC...Thank you very much..This worked perfectly

  8. #8
    Acolyte Sahil1390's Avatar
    Join Date
    Nov 2016
    Location
    India
    Posts
    58
    Articles
    0
    Excel Version
    2007
    Thankyou NBVC

Posting Permissions

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