Results 1 to 7 of 7

Want to covert date format from 13.01.2022 00:00:58.799 this to this 1/13/2022 0:00

Threaded View

  1. 01-13-2022, 10:05 PM #1
    Ali54121
    Ali54121 is offline
    Registered User
    Join Date
    01-09-2022
    Location
    UK
    MS-Off Ver
    2019
    Posts
    7

    Want to covert date format from 13.01.2022 00:00:58.799 this to this 1/13/2022 0:00

    Hi,

    I have date and time in Column A. The format of this date and time is
    13.01.2022 00:00:58.799
    i wan to covert this format to this
    1/13/2022 0:00

    (Also please note that seconds and milliseconds should be removed)

    (Sample file is attached for further clarification)
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« 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. Call in the Cavalry - 2022
    By AliGW in forum The Water Cooler
    Replies: 52
    Last Post: 01-18-2023, 09:35 PM
  2. 2022
    By Glenn Kennedy in forum The Water Cooler
    Replies: 25
    Last Post: 01-09-2022, 05:13 PM
  3. How to make a pivot table using 2021.xls and 2022.xls
    By apekuri in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-03-2022, 06:51 PM
  4. Happy Holidays and a healthy and happy 2022
    By Keebellah in forum Excel General
    Replies: 0
    Last Post: 12-20-2021, 05:26 AM
  5. On off duty cycle chart not working for 2022
    By sham_33rtks in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 12-15-2021, 09:45 AM
  6. [SOLVED] =TEXT Formula for 2022
    By Stenner in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-26-2021, 04:49 AM
  7. [SOLVED] =?iso-2022-jp?B?V2hlcmUgZG9lcyAiYSwbJEIhSRsoQiBjb21lIGZyb20/?=
    By Mike in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-29-2006, 08:30 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