How to Insert Random Time Between 7:30 AM to 8:00 AM in Ms Excel with Interval of 5 Minutes ?
- Hot
- Active
-
Forum Thread: How to Make a Simple Report Card Template in Excel 0 Replies
6 yrs ago -
Forum Thread: How to Insert 'NESTED if' with Ease 0 Replies
6 yrs ago -
Forum Thread: How to Memorise the Excel Formula Syntax 0 Replies
6 yrs ago -
Forum Thread: How to Remove Line Breaks in Excel 0 Replies
6 yrs ago -
Forum Thread: How to Create a Speedometer Chart or Gauge Chart in Excel 0 Replies
6 yrs ago -
Forum Thread: How to Add Dependent Data Validations in Excel 0 Replies
6 yrs ago -
Forum Thread: How to Create a Task Tracker in Excel 0 Replies
6 yrs ago -
Forum Thread: OneNote 2010 document 0 Replies
8 yrs ago -
Forum Thread: How to Turn Off Panning Hand 0 Replies
8 yrs ago -
Forum Thread: While in a Spread Sheet, I Click on One Cell and It Will Auto Highlight Many. Why and How Do I Undo It? 0 Replies
8 yrs ago -
Mail Merge Software: Hello. 0 Replies
8 yrs ago -
Forum Thread: PPTX File Is Giving an Error and Can't Be Opened. 2 Replies
8 yrs ago -
Forum Thread: How to Use Vlookup 0 Replies
8 yrs ago -
Forum Thread: Need Some Help with an Inventory Formula. (Purchase Date)(Sold Date)(Number of Days Held). However, if the Inventory Is 0 Replies
8 yrs ago -
Forum Thread: How to use AND, OR with the IF function 1 Replies
8 yrs ago -
Forum Thread: How to Create a Personal Finance Spreadsheet 0 Replies
8 yrs ago -
Forum Thread: How to Format a Chart Based on Another Chart Format 0 Replies
8 yrs ago -
Forum Thread: Powerpoint Presentation Design 0 Replies
8 yrs ago -
Forum Thread: How to Create Excel Based Interactive Awesome Histograms 0 Replies
8 yrs ago -
Forum Thread: Why Aren't TRUE Excel Based Dashboards More Prevalent? 0 Replies
8 yrs ago
-
How To: Create a Basic Attendance Sheet in Excel
-
How To: Remove spaces from numbers in Excel with the SUBSTITUTE function
-
How To: Create a Tangent Line with Excel
-
How To: Generate random numbers (with decimals) in Excel
-
How To: Multiply column times row with Transpose in MS Excel
-
How To: Conditionally format at every change in value in Excel
-
How To: Find a P-Value with Excel
-
How To: Calculate stock value based on the value of future dividend cash flow in Excel
-
How To: Calculate future & present value for multiple cash flows in Excel
-
How To: Create dynamic sub tables in Microsoft Excel
-
How To: Measure the spread of a data set with Excel's AVEDEV
-
How To: Save Your Word Document as PDF with One Click (Using a Macro)
-
How To: Calculate interest rate risk in Microsoft Excel
-
How To: Clear data & cell contents in Excel using a macro
-
How To: Force text formulas to wrap with Excel's CHAR function
-
How To: Hide scroll bars, sheet tabs & charts in Excel
-
How To: Use conditional formatting for a student grading report in Microsoft Excel
-
How To: Sum only certain columns in Microsoft Excel
-
How To: Find sales price given cost & sales markup in MS Excel
-
How To: Score a Full Version of Microsoft Office for Only $10
1 Response
First create a list in Excel of 7:30, 7:35, 7:40, 7:45, 7:50, 7:55 & 8:00
You will use that list of 7 as a master to randomly select from.
If your list is in A1:A7 for example
Use this formula which pulls out 1 of those 7 values from the list.
=INDEX($A$1:$A$7,RANDBETWEEN(1,7))
Helpful? Here is a useful resource with some free Excel training manuals, have a look.
http://www.microsofttraining.net/excel-training-london.php#resources
Share Your Thoughts