+ Reply to Thread
Results 1 to 3 of 3

Changing Time Zones for Date and Time

  1. 04-03-2014, 05:36 AM #1
    artiststevens
    artiststevens is offline
    Forum Contributor
    Join Date
    10-05-2010
    Location
    CA
    MS-Off Ver
    Excel 365
    Posts
    539

    Question Changing Time Zones for Date and Time

    Hello,
    I need a formula that changes the date and time in EST and make it PST. The original dates start in A2 and original times B2. The formula dates start in D2 and the formula times start in E2. I’ve attached a spreadsheet for a better understanding.

    Thank you in advance for any and all help provided.
    Attached Files Attached Files
    Last edited by artiststevens; 04-03-2014 at 02:51 PM.
    Reply With QuoteRegister To Reply
  2. 04-03-2014, 05:51 AM #2
    Ace_XL
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Changing Time Zones for Date and Time

    In D2
    =INT(A2+B2-3/24)

    In E2
    =MOD(A2+B2-3/24,1)

    Copy down
    Life's a spreadsheet, Excel!
    Say thanks, Click *
    Reply With QuoteRegister To Reply
  3. 04-03-2014, 02:51 PM #3
    artiststevens
    artiststevens is offline
    Forum Contributor
    Join Date
    10-05-2010
    Location
    CA
    MS-Off Ver
    Excel 365
    Posts
    539

    Re: Changing Time Zones for Date and Time

    Thank you very much Ace! I really appreciate it.
    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)

Similar Threads

  1. Function to be added on timestamp Macro to align time of users from different time zones
    By Maxence in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-28-2014, 12:45 PM
  2. Autofill date and time for different time zones
    By brofessional in forum Excel General
    Replies: 0
    Last Post: 12-06-2013, 02:13 PM
  3. Changing time zones
    By qasdzxc in forum Excel General
    Replies: 3
    Last Post: 06-21-2012, 05:46 PM
  4. Changing time w/zones
    By jjjamiem in forum Excel General
    Replies: 2
    Last Post: 09-16-2006, 02:37 AM
  5. [SOLVED] Date/Time in different time zones
    By Josh Sale in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-10-2005, 07:06 PM

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