- Home
- Software
- Office / Productivity
- Office Suites
- MS Office
- MS Excel
- MS Excel random date and time simulator
Advertisement
| Hall of Fame |
- 1. rorya515,325
- 2. zorvek472,359
- 3. barryhou...328,824
- 4. teylyn320,146
- 5. saurabh726261,199
- 6. matthews...233,962
- 7. chris_bot...212,944
- 8. brettdj209,325
- 9. patrickab173,172
- 10. nutsch156,877
- 11. broomee9156,055
- 12. WarCrimes151,814
- 13. byundt124,584
- 14. pari123123,346
- 15. jppinto95,105
- 16. krishnakrkc83,676
- 17. TomSchre...65,232
- 18. ahammar60,500
- 19. bromy200453,504
- 20. GrahamSkan50,953
- 21. gowflow45,000
- 22. folderol44,200
- 23. spattewar42,702
- 24. hitsdoshi140,804
- 25. robhenson40,326
- 1. zorvek11,276,056
- 2. rorya9,414,172
- 3. byundt8,381,896
- 4. saurabh7265,401,445
- 5. matthews...4,282,643
- 6. brettdj3,554,492
- 7. patrickab3,393,909
- 8. jeverist2,922,207
- 9. chris_bot...2,347,706
- 10. barryhou...1,950,179
- 11. roos011,928,098
- 12. webtubbs1,880,710
- 13. mvidas1,546,321
- 14. nutsch1,507,947
- 15. fanpages1,236,922
- 16. MalicUK1,060,396
- 17. ahammar1,007,778
- 18. spattewar803,305
- 19. pari123678,819
- 20. mgh_mgh...649,110
- 21. LoNeRaV...602,049
- 22. WarCrimes592,435
- 23. ture572,551
- 24. david251504,426
- 25. epaclm502,595
|
[x]
Posted via EE Mobile
|
||
Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again. |
||
| Question |
|
[x]
Attachment Details
|
||
|
[x]
The Solution Rating System
|
||
With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.
Your Input Matters If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support. Thank you! |
||
MS Excel random date and time simulator
Asked by Tlogix in Microsoft Excel Spreadsheet Software
Tags: excel
I need to populate a spreadsheet with data that would simulate events over the course of a work week, this would meet generaing random numbers with conditions, the following is an example:
Condition 1: Work week is M-F 8am-5pm
Condition 2: The events can have a range between 3 mins to 1 hour
Condition 3: The interval between events can range between 1 min and 40 mins.
So the example would be this
Event | Date | Time | Duration
1 | 03/03/2003 | 08:35:15 | 0:04:45
2 | 03/03/2003 | 08:41:00 | 0:08:00
3 | 03/03/2003 | 08:54:26 | 0:48:16
> Event one lasted 4m 45sec, there was a 1 min interval before event two
> Event two lasted 8 mins, there was a 5min 26 sec interval before event 3 which lasted 48min 16sec.
> The events would continue like this based on the above conditons until 17:00 was reached (which can be exceeded for the last entry).
> The next events would start on the next calendar day randomly also from 8:00am.
I would prefer this in a VBA maro solution and notes about how I can change the the variables. If you require more columns or something, that would be fine..I just need the values really to plug into a DB.
(newbie here...thansk in advance).
| [+][-]05/31/05 01:50 PM, ID: 14116817Accepted Solution |
Your question has an Asker Certified™ answer! Tlogix verified that this solution worked for them--which means it will likely work for you, too. Click to view the solution free for 30-days now.
