LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Tiffany
 
Posts: n/a
Default Random Times

Ok. I guess the government had to go and make this even more difficult for
me.

I need to figure out how to get random times for check during one day using
an Excel spreadsheet.

They start at 6:00 a.m. up until about 6:00 p.m. They have to be no more
than 55 minutes apart, but less than 15 min apart. They cannot be between
10:00 am and 10:30 am.

I received a response to my last question which was between 6 and 6pm, no
more than 55 min apart and not between 10 and 10:30 am. I set it up. It works
wonders. But, now I'm told they have to be at least 15 min apart. I tried to
adjust the formula accordingly, but I just can't figure it out.

Can anyone help me please???
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
Charting and analyzing Times' times data for trends Johnny Excel Discussion (Misc queries) 1 May 5th 05 01:36 AM
Random Times Tiffany Excel Worksheet Functions 1 May 4th 05 03:47 PM
Selecting at random with weighted probability Damage Excel Worksheet Functions 2 January 31st 05 11:06 PM
Formulas stop calculating at random times when editing a few spreadsheets. Luke MacNeil Excel Discussion (Misc queries) 3 November 30th 04 03:21 PM


All times are GMT +1. The time now is 05:48 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"