+ Reply to Thread
Results 1 to 10 of 10

Count trigger as timer?

Hybrid View

  1. 09-03-2017, 02:48 PM #1
    QuantEdge
    QuantEdge is offline
    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
    Reply With QuoteRegister To Reply
  2. 09-03-2017, 03:21 PM #2
    Estevaoba
    Estevaoba is offline
    Forum Expert
    Join Date
    06-05-2017
    Location
    Brazil
    MS-Off Ver
    Microsoft 365 Version 2412
    Posts
    1,508

    Re: Count trigger as timer?

    Assuming timer value is minutes, try this at A5:

    =B3+C1/1440

    Godspeed!
    Reply With QuoteRegister To Reply
  3. 09-03-2017, 03:38 PM #3
    QuantEdge
    QuantEdge is offline
    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
    Reply With QuoteRegister To Reply
  4. 09-03-2017, 09:50 PM #4
    Root_
    Root_ is offline
    Valued Forum Contributor Root_'s Avatar
    Join Date
    07-29-2017
    Location
    _
    MS-Off Ver
    2010+
    Posts
    514

    Re: Count trigger as timer?

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

    =IF(IFERROR(OFFSET(A1,-$C$1+1,0),"")="Start","End","")
    Reply With QuoteRegister To Reply
  5. 09-03-2017, 11:20 PM #5
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2503
    Posts
    13,710

    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 
    =IFERROR(IF(MATCH(ROWS($1:1),IF($A$1:$A$17="Start",(ROW($A$1:$A$17)-1)+$C$1),0),"End"),"")
    Dave
    Reply With QuoteRegister To Reply
  6. 09-09-2017, 12:06 PM #6
    QuantEdge
    QuantEdge is offline
    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.
    Reply With QuoteRegister To Reply
  7. 09-09-2017, 12:33 PM #7
    Root_
    Root_ is offline
    Valued Forum Contributor Root_'s Avatar
    Join Date
    07-29-2017
    Location
    _
    MS-Off Ver
    2010+
    Posts
    514

    Re: Count trigger as timer?

    Quote Originally Posted by QuantEdge View Post
    ... ** for all.
    Not sure about the meaning of the "**".
    Reply With QuoteRegister To Reply
  8. 09-10-2017, 04:59 AM #8
    xlnitwit
    xlnitwit is offline
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    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.
    Reply With QuoteRegister To Reply
  9. 09-10-2017, 10:05 AM #9
    Root_
    Root_ is offline
    Valued Forum Contributor Root_'s Avatar
    Join Date
    07-29-2017
    Location
    _
    MS-Off Ver
    2010+
    Posts
    514

    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.
    Reply With QuoteRegister To Reply
  10. 09-11-2017, 07:34 PM #10
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 V 2503
    Posts
    13,710

    Re: Count trigger as timer?

    Thanks for the feedback and marking this Solved.
    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. 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1