+ Reply to Thread
Results 1 to 4 of 4

Do something if time is + 1 minute

  1. #1
    Registered User
    Join Date
    03-22-2023
    Location
    Netherlands
    MS-Off Ver
    Office365
    Posts
    2

    Cool Do something if time is + 1 minute

    Hi all,

    I'm trying to fix something..

    I have a macro showing me date and time live. I want to make a condition that says if the time is + one minute, cell x needs to be substracted from cell y. Is this even possible? can you guys please take a look
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2016
    Posts
    949

    Re: Do something if time is + 1 minute

    try
    msgbox will show after 1 min modify accordingly
    removed exit sub if you want to continue running the sub
    i used a value of 62 because visually counting the seconds on the live clock somehow equates to 60 counts
    Please Login or Register  to view this content.
    Last edited by k1dr0ck; 03-22-2023 at 09:14 PM.

  3. #3
    Registered User
    Join Date
    03-22-2023
    Location
    Netherlands
    MS-Off Ver
    Office365
    Posts
    2

    Re: Do something if time is + 1 minute

    thanx for the reply, i can't get this to work somehow? nothing happens

  4. #4
    Valued Forum Contributor
    Join Date
    12-01-2011
    Location
    Philippines
    MS-Off Ver
    Excel 2016
    Posts
    949

    Re: Do something if time is + 1 minute

    run the sub it will show the live clock after 1 min a msgbox will show then stops the live clock

    put your desired code inside the if statement
    removed EXIT SUB inside the if statement if you want to continue running the sub
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Increase Time by 1 minute in custom Date/Time Format
    By godawgs in forum Excel General
    Replies: 1
    Last Post: 09-07-2018, 09:32 AM
  2. [SOLVED] Convert time to minute
    By nazdiana in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-24-2018, 03:40 AM
  3. [SOLVED] Add 1 minute to a shift time
    By manny88 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 03-22-2017, 11:58 AM
  4. Calculating Time by Minute and Second
    By Cardan in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 05-22-2016, 09:43 PM
  5. [SOLVED] Record on/off time for minute by minute data set
    By bdenzer in forum Excel General
    Replies: 5
    Last Post: 07-30-2015, 07:41 PM
  6. Replies: 6
    Last Post: 11-26-2014, 10:35 PM
  7. [SOLVED] convert time from 60 minute hour to 100 minute hour
    By Jboerding in forum Excel General
    Replies: 2
    Last Post: 07-06-2005, 06:30 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1