+ Reply to Thread
Results 1 to 10 of 10

Count trigger as timer?

  1. #1
    Forum Contributor
    Join Date
    08-18-2017
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    308

    Count trigger as timer?

    anyone know how to trigger a label in a row after a special time range?

    explained more clearly in sheet
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    365
    Posts
    378

    Re: Count trigger as timer?

    Assuming timer value is minutes, try this at A5:

    =B3+C1/1440

    Godspeed!

  3. #3
    Forum Contributor
    Join Date
    08-18-2017
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    308

    Re: Count trigger as timer?

    sorry Estevaoba, does not work ... timer value is minutes

  4. #4
    Valued Forum Contributor Root_'s Avatar
    Join Date
    07-29-2017
    Location
    _
    MS-Off Ver
    2010+
    Posts
    421

    Re: Count trigger as timer?

    Maybe this in B1 (and drag-copied down):

    =IF(IFERROR(OFFSET(A1,-$C$1+1,0),"")="Start","End","")

  5. #5
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,606

    Re: Count trigger as timer?

    Another way array entered in B1 and filled down. If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Dave

  6. #6
    Forum Contributor
    Join Date
    08-18-2017
    Location
    London
    MS-Off Ver
    Excel 2016
    Posts
    308

    Re: Count trigger as timer?

    nice one both work amazing... ** for all.

  7. #7
    Valued Forum Contributor Root_'s Avatar
    Join Date
    07-29-2017
    Location
    _
    MS-Off Ver
    2010+
    Posts
    421

    Re: Count trigger as timer?

    Quote Originally Posted by QuantEdge View Post
    ... ** for all.
    Not sure about the meaning of the "**".

  8. #8
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,083

    Re: Count trigger as timer?

    Quote Originally Posted by Root_ View Post
    Not sure about the meaning of the "**".
    I think he means rep- as in the * in the bottom left corner.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

  9. #9
    Valued Forum Contributor Root_'s Avatar
    Join Date
    07-29-2017
    Location
    _
    MS-Off Ver
    2010+
    Posts
    421

    Re: Count trigger as timer?

    Quote Originally Posted by xlnitwit View Post
    I think he means rep- as in the * in the bottom left corner.
    Nope. Not rep.

  10. #10
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    2007, Office 365
    Posts
    11,606

    Re: Count trigger as timer?

    Thanks for the feedback and marking this Solved.

+ 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. EDIT: If-Then-Else Count Down Timer
    By HGL in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-05-2016, 09:18 AM
  2. Count down timer
    By Marcel Coetzee in forum PowerPoint Formatting & General
    Replies: 1
    Last Post: 07-14-2015, 11:36 AM
  3. COunt down timer help please.....
    By lbjohnston in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-01-2012, 10:20 AM
  4. [SOLVED] Count Rows Based On User Input & Trigger Print Of Pages Out Of Count Result
    By wliang in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2012, 02:45 AM
  5. Count down time and count up timer does not starts in another sheet(s)
    By marc5354 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-03-2010, 06:08 PM
  6. Count down time and count up timer does not starts in another sheet(s)
    By marc5354 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-01-2010, 07:52 AM
  7. count down timer
    By RAF JANSSENS in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-05-2006, 06:51 AM

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