+ Reply to Thread
Results 1 to 2 of 2

Change UTC date format

  1. 09-09-2019, 12:15 AM #1
    excellearner09
    excellearner09 is offline
    Registered User
    Join Date
    09-09-2019
    Location
    melbourne
    MS-Off Ver
    office365
    Posts
    2

    Change UTC date format

    Hi Experts,

    I am trying to convert UTC date formation to AEST(Australia Eastern Standard Time format.

    sample date : 2018-12-11T02:55:24.000Z


    Kindly assist.

    regards
    Avi
    Reply With QuoteRegister To Reply
  2. 09-09-2019, 03:27 AM #2
    Olly
    Olly is offline
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Change UTC date format

    You could use Power Query (Get & Transform Data) - something like:

    Please Login or Register  to view this content.


    Or with formulas:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.


    With formatting:
    Formula: copy to clipboard 
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...
    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. Change format to date format if cell populated with a date
    By Lbelden78 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 07-22-2019, 08:26 AM
  2. Show Error when a cell with number format change to date format
    By delroba in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-08-2015, 02:57 AM
  3. [SOLVED] Date formula - Change Format to YYYYMMDD from Exported Format
    By haleakala17 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 03-21-2014, 03:22 PM
  4. [SOLVED] help on vba code to change the error date format as standard format mm/dd/yyyy
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-13-2013, 01:10 AM
  5. Excel:How change the textbox format from text to date format?
    By inpetto in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-10-2013, 08:23 AM
  6. Not able to change date format into proper excel date format
    By excel5111987 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2011, 08:19 AM
  7. Userform date format reverting back to us format on change event
    By jpruffle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-10-2009, 12:34 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