Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I need to generate random times of the day between 6am and 6pm. They cannot
be any more than 55 minutes apart. And cannot be between 10:00 am and 10:30 am. I have tried everything I know and cannot come up with anything. Anyone know of a function I can use to produce this automatically every day? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
Selecting at random with weighted probability | Excel Worksheet Functions | |||
SUMPRODUCT ON TIMES | Excel Worksheet Functions | |||
Formulas stop calculating at random times when editing a few spreadsheets. | Excel Discussion (Misc queries) |