Consulting

Results 1 to 2 of 2

Thread: macro to add or subtract date and time from yyyymmdd_hhmmss format

  1. #1
    VBAX Newbie
    Joined
    Jan 2023
    Posts
    1
    Location

    macro to add or subtract date and time from yyyymmdd_hhmmss format

    Might anyone already have a VBA macro to add or subtract time and date from a string in yyyymmdd_hhmmss (e.g. 20230102_233411) format? The subtracting is giving me fits :)

    Thanks!

  2. #2
    if the Cell is Formatted as such, you can easily carry out the subtraction/addition.
    but if they are String values, you need to convert them first to Real date/time then you can do the addition/subtraction.

Tags for this Thread

Posting Permissions

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