+ Reply to Thread
Results 1 to 4 of 4

Increase or Decrease times in time stamp, stored in the cells

  1. 11-17-2014, 05:42 AM #1
    igor7 is offline
    Registered User
    Join Date
    12-14-2013
    Location
    Ukraine
    MS-Off Ver
    Excel 2013
    Posts
    25

    Increase or Decrease times in time stamp, stored in the cells

    Hi, there!
    I need to increase or decrease times in time stamp, stored in the cells in following format:
    2/12/2010 3:53:02 PM
    Actually I need to increase or decrease minutes in time stamp in whole column G (G5:G360).
    For example if G5 cell contain 2/12/2010 3:53:02 PM I need to add 4 minutes to the time stamp, so it will be 2/12/2010 3:57:02 PM.
    And do so to whole range G5:G360 (add 4 minutes). Can I automate this task with VB or macro?
    Thank you in advance,
    Igor
    Reply With QuoteRegister To Reply
  2. 11-17-2014, 06:18 AM #2
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Increase or Decrease times in time stamp, stored in the cells

    Hi,

    Use this code :

    Please Login or Register  to view this content.
    Select your range (G5:G360) and run the macro.

    Regards
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important
    Reply With QuoteRegister To Reply
  3. 11-17-2014, 06:22 AM #3
    igor7 is offline
    Registered User
    Join Date
    12-14-2013
    Location
    Ukraine
    MS-Off Ver
    Excel 2013
    Posts
    25

    Re: Increase or Decrease times in time stamp, stored in the cells

    Thank you for help!! it's work!!
    Reply With QuoteRegister To Reply
  4. 11-17-2014, 07:22 AM #4
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Increase or Decrease times in time stamp, stored in the cells

    You are welcome, and please mark this thread as SOLVED, thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Count Occurrences of time stamp bewteen two times from DateTime Column
    By headric in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-18-2014, 09:08 AM
  2. Merged Cells - Autofit Increase or Decrease Height when Cell is Edited
    By snapfade in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-17-2013, 03:24 PM
  3. $20 increase/decrease in price, 50,000 decrease/increase in the number of units sold
    By Michaael01 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-18-2012, 01:01 AM
  4. Percentage of increase/decrease for time
    By buzzkill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2012, 10:43 AM
  5. Automatic Increase/Decrease in Row Height and Column Width in cells
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 12-23-2010, 02:39 PM

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