Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increasing number automatically
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increasing number automatically
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 a 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 "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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Increasing number automatically
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why is my spreadsheet increasing to maximum size automatically? | Excel Discussion (Misc queries) | |||
increasing invoice number automatically | Excel Worksheet Functions | |||
Automatically increasing a number by 1 | Excel Discussion (Misc queries) | |||
Increasing Number | Excel Discussion (Misc queries) | |||
how can I copy dates, etc. without them automatically increasing | Excel Discussion (Misc queries) |