Results 1 to 2 of 2

Thread: Date edit VBA
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2019
    Posts
    7
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Date edit VBA

    Any help on this would be greatly appreciated. I have already tried recording a macro but to no avail.
    I have a wkbk with 6 sheets, and each one has a date corresponding to the data in the form of 2019:129:14:18:31.274 YYYY:DDD(day of the year as in 129th day):HH:MM:SS.sss
    I would like to turn that date which excels reads as text and remove some of the unneeded precision such that it reads YYYY:DDD:HH and in such a way that excel can recognize that it is a date. So if the previously mentioned format has to be altered to include months somehow that would be acceptable. The date data always starts in Cell A2 of each worksheet. Additionally, because of the precision some of the data that is recorded has slightly different times 2019:129:14:18:31.274 and 2019:129:14:18:32.274 because it is received at a difference second. If possible I would like to combine the data such that all of that data at any given year/day/hour is on the same row. Thanks in advance

  2. #2
    Board Regular synergy16's Avatar
    Join Date
    Mar 2016
    Location
    new england
    Posts
    389
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Date edit VBA

    you want to change the date IN the worksheet itself or the name of the worksheet?

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •