- Sep 18, 2014
How can I generate a random time based on a given time thats within plus or minus a set amount of time, say 30 minutes before or after. For example, I have a cell which contains the time 15:30:00. I want to generate a random time that is based on that cell and can be anywhere between 15:00:00 and 16:00:00. Is this possible in excel? Thanks for the help.