Increasing number automatically

[Steve]

Hi,
I was wondering if someone can help me. I was want to know if it is possible
to set for number to automatically increase per hour??
e.g. If you have 100 cakes and you can make 17 cakes per hour, can you set
it up to automatically increase by 1 every 3.5 seconds? and still work when
you have sold 10 cakes and taken them off the total.

Any help would be much appreciated.

Steve

P.s. i dont work with cakes, so please dont ask for any cakes,muffins or
anything like that as a reward for helping.

 

[Markus Fischer]

Steve,

You will need at least a VBA code that will prompt the spreadsheet to
recalculate every hour (you can simulate this by hitting F9 to recalculate).
Once you have implemented that, all the rest can be done in formulas:

A | B | C | D
| E | F |
Rate (u/hr)| Start date | Start time | Current date | current time |
Units |
17 | 23/09/2008 | 15:36:09 | Formula1 | Formula2 |
Formula 3 |


The titles are on row 1 and the values on row 2. The formulas are:
Formula 1: "= TODAY()"
Formula 2: "= NOW()"
Formula 3: "=(24*DAYS360(B2,D2)+HOUR(E2-C2))*A2"

This should now work fine. Make sure that cells B2 and D2 are formatted as
date and cells C2 and E2 as time.

Please let me know if this answers your question.

Markus

 

[Gord Dibben]

Steve

Your arithmetic is off.

Should be one cake every 3.5 minutes.......not seconds.

You would need VBA and the OnTime method to run a counter every 3.5 minutes.

See Chip Pearson's site for code.

http://www.cpearson.com/excel/OnTime.aspx


Gord Dibben MS Excel MVP