Results 1 to 10 of 10

Thread: Random Time Between Fixed Lower And Upper Limits

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 07-19-2013, 11:09 PM #6
    testingcode
    testingcode is offline
    Junior Member
    Join Date
    Jun 2013
    Posts
    13
    Rep Power
    0
    Are you wanting 6-9am in the Stretches column, 11am-2pm in the Running warmups column, ect..?

    If so, then you can just use the
    Code:
    =TIME(6,RANDBETWEEN(0,180),0)
    in the correct column and adjust the bolded numbers to whatever time frame is needed for that column. The example formula above would be for the Streches column.
    Last edited by testingcode; 07-19-2013 at 11:25 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Custom Charts in Excel :: Comparison RAG Chart Showing Tolerance Limits
    By Transformer in forum Tips, Tricks & Downloads (No Questions)
    Replies: 0
    Last Post: 06-13-2013, 09:40 PM
  2. Calculate Time Difference Between Time In HH:MM
    By Stalker in forum Excel Help
    Replies: 8
    Last Post: 03-28-2013, 03:27 PM
  3. Fixed asset Register
    By Howardc in forum Excel Help
    Replies: 1
    Last Post: 11-14-2012, 10:20 AM
  4. Reverse name in excel with upper case,edit formula
    By shrinivasmj in forum Excel Help
    Replies: 3
    Last Post: 09-11-2012, 01:31 PM
  5. Spreading a time range (shift time, etc) in columns.
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 1
    Last Post: 08-23-2011, 11:45 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules