+ Reply to Thread
Results 1 to 2 of 2

Creating Random Times past midnight -help!

  1. #1
    Registered User
    Join Date
    02-26-2015
    Location
    Sheffield, England
    MS-Off Ver
    2011
    Posts
    1

    Creating Random Times past midnight -help!

    Hi,

    I was really hoping that somebody with better excel skills that me might be able to help! I'm trying to generate a list of random times between 21:30 and 02:30am for my research and I can't seem to do it in excel.

    I've been able to generate random times that don't go past midnight on the same day using this formula:
    =TIME(21,30,0)+RAND()*TIME(22,30,0)-TIME(21,30,0))

    If anyone could help me then I would really appreciate it!

    Best wishes

  2. #2
    Forum Expert tim201110's Avatar
    Join Date
    10-23-2011
    Location
    Russia
    MS-Off Ver
    2016, 2019
    Posts
    2,357

    Re: Creating Random Times past midnight -help!

    Mod(randbetween(1290,1590),1440)/1440

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Difference between two times - avoiding ###### for times that span midnight
    By Abarency in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-07-2015, 01:15 PM
  2. [SOLVED] Calculating time that goes past Midnight
    By jonvanwyk in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 02-27-2013, 04:14 PM
  3. Replies: 3
    Last Post: 07-26-2012, 10:50 AM
  4. Calculate time which is past midnight
    By stoey in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 08-25-2011, 12:11 PM
  5. [SOLVED] Calculating Time Past Midnight
    By Darren in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-13-2006, 11:03 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1