+ Reply to Thread
Results 1 to 7 of 7

Remove Timestamp From Date/Time Entry

  1. #1
    Registered User
    Join Date
    10-22-2015
    Location
    Independence, OH
    MS-Off Ver
    10
    Posts
    3

    Remove Timestamp From Date/Time Entry

    Hello All,
    The Google suggestions have not worked. I have version 10.

    I need to pivot and I need date only. Entries read: 10/20/2015 1:47:23 PM

    I have tried to format the entry to just date. It has not worked.

    Anyone else had this issue that can help?

    Thanks!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    47,610

    Re: Remove Timestamp From Date/Time Entry

    If formatting didn't work, the chances are that it is text that just looks like a date and time. If, for example, you have a true numeric date and time in cell A2 then the formula =INT(A2) formatted as date would work. As it is, I think you will need to use the DATE function with MID To extract year, month and day.

    Suggest you post a sample workbook.


    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Remove Timestamp From Date/Time Entry

    You can remove the timestamp with the INT function

    =INT(A1)

    Then use the column with that formula for your pivot table.

  4. #4
    Registered User
    Join Date
    10-22-2015
    Location
    Independence, OH
    MS-Off Ver
    10
    Posts
    3

    Re: Remove Timestamp From Date/Time Entry

    Thanks for your respones. I have tried and it doesn't work for me.
    The formula goes in the first cell where the date and time stamp is correct? The cell reference int he formula is where the date only is going to move to correct?

  5. #5
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Remove Timestamp From Date/Time Entry

    The formula goes in the first cell where the date and time stamp is correct?
    No, if there is already a date and time there, you cannot put a formula
    The cell reference int he formula is where the date only is going to move to correct?
    For the formula =INT(A1), A1 is the cell where the date and time stamp is. The cell where you put the formula will only show the date.

    Hope that helps. You should upload a workbook (Go Advanced>Manage Attachments)
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble

  6. #6
    Registered User
    Join Date
    10-22-2015
    Location
    Independence, OH
    MS-Off Ver
    10
    Posts
    3

    Re: Remove Timestamp From Date/Time Entry

    I decided to work from a new spreadsheet and the formula is Working!

    Many thanks to all of you for your posts!

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    47,610

    Re: Remove Timestamp From Date/Time Entry

    You're welcome.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. CountIf Formula for Time within Date Timestamp
    By Cookiemonstuh in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-15-2015, 03:13 PM
  2. [SOLVED] Separating Time and Date for Timestamp
    By Grimace in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-16-2014, 08:37 PM
  3. Help to remove timestamp from date in Excel 2007
    By Spaz1 in forum Excel General
    Replies: 2
    Last Post: 05-29-2013, 09:12 AM
  4. remove timestamp from date
    By surfengine in forum Excel General
    Replies: 2
    Last Post: 03-03-2010, 05:43 PM
  5. Help! How can I remove the date from a timestamp?
    By juddh in forum Excel General
    Replies: 1
    Last Post: 09-23-2009, 12:14 PM
  6. Timestamp (Date+Time) macro?
    By gryphq in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-01-2006, 04:08 PM
  7. Remove Timestamp from date
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-07-2006, 03:45 AM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1