+ Reply to Thread
Results 1 to 5 of 5

Formula to con

  1. 07-19-2022, 10:16 AM #1
    rexcel548562
    rexcel548562 is offline
    Forum Contributor
    Join Date
    07-10-2022
    Location
    USA
    MS-Off Ver
    2021
    Posts
    190

    Formula to con

    Hi,

    I have tim
    Last edited by rexcel548562; 08-07-2022 at 08:39 AM.
    Reply With QuoteRegister To Reply
  2. 07-19-2022, 10:27 AM #2
    Pete_UK
    Pete_UK is offline
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,790

    Re: Formula to convert Timestamp from "02-02-2022 1:03:03 AM" this to "02-02-2022" this

    You could use this formula in H6:

    =INT(G6)

    though I'm not sure that is exactly what you are after. If you want the result to be in cell G6 then you will need a bit of VBA for that.

    Hope this helps.

    Pete
    Reply With QuoteRegister To Reply
  3. 07-19-2022, 10:27 AM #3
    Pepe Le Mokko
    Pepe Le Mokko is offline
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,448

    Re: Formula to convert Timestamp from "02-02-2022 1:03:03 AM" this to "02-02-2022" this

    Try =INT(G6) and format as required
    How to paste Power Query code ( by Olly)
    Reply With QuoteRegister To Reply
  4. 07-19-2022, 10:43 AM #4
    rexcel548562
    rexcel548562 is offline
    Forum Contributor
    Join Date
    07-10-2022
    Location
    USA
    MS-Off Ver
    2021
    Posts
    190

    Re: Formula to convert Timestamp from "02-02-2022 1:03:03 AM" this to "02-02-2022" this

    Hi Sir Pepe Le Mokko,
    Last edited by rexcel548562; 08-07-2022 at 08:39 AM.
    Reply With QuoteRegister To Reply
  5. 07-19-2022, 10:43 AM #5
    rexcel548562
    rexcel548562 is offline
    Forum Contributor
    Join Date
    07-10-2022
    Location
    USA
    MS-Off Ver
    2021
    Posts
    190

    Re: Formul

    Hi Sir Pete UK,
    Last edited by rexcel548562; 08-07-2022 at 08:39 AM.
    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. [SOLVED] How do I create formula for "All 2022 Mondays" as Column headers, in date format?
    By Zenmusicman in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 02-04-2022, 05:51 PM
  2. Formula or macro that can highlight a "difference" or "missing" timestamp from a list
    By xosder33 in forum Excel General
    Replies: 2
    Last Post: 04-19-2021, 08:01 PM
  3. Tried formula variations including "if", "sumif", "min", "match" but can't get it to work.
    By bjorn123 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-19-2020, 08:30 PM
  4. [SOLVED] Brief formula to convert time values to "shift1", "shift2", "shift3".
    By darekpawel in forum Excel Formulas & Functions
    Replies: 20
    Last Post: 04-11-2019, 07:05 AM
  5. Budget assist: Entering "Weekly" "Fortnightly" "Monthly" OR "Yearly" with formulas
    By Windyz in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-05-2019, 12:03 AM
  6. [SOLVED] Column X-Ref list - Sheet1 Col A "pages", Col B:FL "Req" to Sheet2 ColA "req", ColB "page"
    By excel-card-pulled in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 04-07-2017, 09:30 AM
  7. [SOLVED] Excel 2007: How to Convert "5/2/2013" to "May" then subtract a Month so it's "Apr"
    By Golom in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-19-2013, 02:00 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1