helix123
10-03-2012, 08:03 PM
Sorry if this problem is a bit a long but here goes:
At the moment I have a budget amount (say $30,000) and then have a user defined function which subtracts off each cost per minute (which varies minute to minute) until the budget runs out i.e. it counts the number of iterations/loops that the initial budget lasted for given that it started from a particular minute.
Thus the udf MinutePaidInFullc gives the number of minutes a particular budget amount will last before reaching zero starting from any given minute.
http://www.vbaexpress.com/forum/showthread.php?t=43802
However, as an extension to this problem I have a clock timer macro which shows what minute it is up to.
What I would like to have is the MinutesPaidInFullc user defined function to dynamically update as the minutes progress i.e. the minute on the clock becomes the start minute in the MinutePaidInFullc function.
See the attached workbook for more details. NOTE: make sure the format of cell G6 is set to general.
Any help would be much appreciated.
At the moment I have a budget amount (say $30,000) and then have a user defined function which subtracts off each cost per minute (which varies minute to minute) until the budget runs out i.e. it counts the number of iterations/loops that the initial budget lasted for given that it started from a particular minute.
Thus the udf MinutePaidInFullc gives the number of minutes a particular budget amount will last before reaching zero starting from any given minute.
http://www.vbaexpress.com/forum/showthread.php?t=43802
However, as an extension to this problem I have a clock timer macro which shows what minute it is up to.
What I would like to have is the MinutesPaidInFullc user defined function to dynamically update as the minutes progress i.e. the minute on the clock becomes the start minute in the MinutePaidInFullc function.
See the attached workbook for more details. NOTE: make sure the format of cell G6 is set to general.
Any help would be much appreciated.