+ Reply to Thread
Results 1 to 3 of 3

Calculate a new date/time based on the input

  1. #1
    Registered User
    Join Date
    08-20-2007
    Posts
    60

    Calculate a new date/time based on the input

    Hello,

    I store a time stamp in a variable called STIME.

    For example, STIME = 7/26/27 10:05:51PM (always be some time after 7PM), I want to change the value to 7AM next morning.

    That is, need to change STIME as 7/27/2007 07:00:00AM

    How do I do this in a macro?

    Thanks, Anil
    Last edited by akabraha; 09-17-2007 at 06:16 PM.

  2. #2
    Forum Expert mikerickson's Avatar
    Join Date
    03-30-2007
    Location
    Davis CA
    MS-Off Ver
    Excel 2011
    Posts
    6,229
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    08-20-2007
    Posts
    60
    Perfect - you are too good and quick

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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