Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am using Excel to try to come up with a schedule for when I will be doing my rounds. I have to do them wwithin thirty (30) minutes from the last time and I don't want to go less than 25 minutes apart. I also don't care if some are 30 mins.

Therefore how do I come up with a formula where I add a random time interval between 25 and 30 minutes to the previous row's time value?

share|improve this question

closed as not a real question by Oliver Salzburg Aug 24 '12 at 0:06

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

    
If rand() returns a pseudo-random number between 0 and 1.0 inclusive, then the the next interval is 5*rand() + 25. –  sawdust Aug 23 '12 at 23:32
add comment

1 Answer

Let's say in A1 you enter the time of the first round:

08:00

Then you can create the following formula in A2:

=A1+time(0;randbetween(25;30);0)

(Replace semicolons with commas if that's what your regional settings dictate.)
And copy/paste that cell downwards for as many rounds you need to run.

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.