Random Time...Help please

[kayboom]

ok...i have A and B shift audits that need to be done. I need computer generated times to apprea so the QA techs know when to audit.

A shift random times are 8 am - 4 pm
B shift random times are 5 pm - 1 am

these need to change daily....any help would greatly be appreciated. Im sure its something so easy but im making a mountain out of a mole hill.....its my MO lol

Thank you soooo much in advance...i so appreciate it!

 

[UniMord]

For 8:00 AM - 4:00 PM use: =RAND() * 1/3 + 1/3
For 5:00 PM - 1:00 AM use: =RAND() * 1/3 + 17/24

Remember to format as time!

 

[kayboom]

thank you so much! works like a charm. But I have a question so I understand the formula.

what is the 1/3=17/24? im assuming the 17/24 is 5pm to 12 midnight...correct? but how does the 1/3+1/3 equate out?