+ Reply to Thread
Results 1 to 4 of 4

Start 10 mins 25 sec from Now

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    08-28-2012
    Location
    nz
    MS-Off Ver
    Excel 2010
    Posts
    125

    Red face Start 10 mins 25 sec from Now

    Hi Guru's

    Is this right if i want the time for this to start, at varying minutes from "Now", linked to those cells ? and will it read contents of cells as time.


    Thanks in advance

    Mike



    HTML Code: 

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,969

    Re: Start 10 mins 25 sec from Now

    This will do what you want, assuming that Sheets("race").Range("aa569") has the number of minutes, and Sheets("race").Range("ab569") has the number of seconds.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Contributor
    Join Date
    08-28-2012
    Location
    nz
    MS-Off Ver
    Excel 2010
    Posts
    125

    Re: Start 10 mins 25 sec from Now

    Hi 6StringJazzer

    Thanks for that

    I'm a Guitar player as well, Love it : ) cool : ).

    I'm Wondering if you might know why, when "RunOnTimeStartBlink" is called it actually starts the "StartBlink" straight away ?

    I don't know, excel is making me crazy : )

    Cheers

  4. #4
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,969

    Re: Start 10 mins 25 sec from Now

    For all practical purposes it calls StartBlink right away. First it schedules itself to run again, which takes a very small amount of time, then it calls StartBlink.

+ 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. Replies: 3
    Last Post: 05-22-2012, 03:26 PM
  2. Time Converter : Mins/Secs to Hours/Mins
    By jamesgsi1983 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-23-2009, 09:02 AM
  3. OT :Start your own online business today !start making dollars
    By ag281962@hotmail.com in forum Excel General
    Replies: 0
    Last Post: 05-06-2006, 04:35 PM
  4. Replies: 8
    Last Post: 01-07-2006, 03:35 PM
  5. [SOLVED] How to convert numeric value to mins and addimg mins to Hrs.
    By ramana in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-28-2005, 06:05 AM

Tags for this Thread

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