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

On Tue, 23 Sep 2008 08:25:01 -0700, Steve
wrote:

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.