+ Reply to Thread
Results 1 to 5 of 5

random time between starting and ending time

  1. #1
    Forum Contributor
    Join Date
    12-23-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2016
    Posts
    358

    random time between starting and ending time

    Hi All, I want to put random time, between two time ranges.
    in column D the time is starting time and then in the next column i.e. E random numbers I want to add these numbers in the starting time to make ending time in column F
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: random time between starting and ending time

    I am not sure but this should help, i think you should give the random in time format HH:mm:SS.
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    12-23-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2016
    Posts
    358

    Re: random time between starting and ending time

    THANKS FOR YOUR REPLY

    if column D is AM and column F is PM then how do i get the result please see the picture
    i dont want as 19:30 but to see 7:30 PM
    Attached Images Attached Images

  4. #4
    Forum Expert
    Join Date
    03-28-2014
    Location
    Hyderabad,India
    MS-Off Ver
    Excel 2013
    Posts
    1,887

    Re: random time between starting and ending time

    Check this , you may also find other methods from other forum members
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    12-23-2012
    Location
    Pakistan
    MS-Off Ver
    Excel 2016
    Posts
    358

    Re: random time between starting and ending time

    Okay dear thanks i got it.

+ 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. Average of ending time in a columns
    By ludovic_44 in forum Excel General
    Replies: 1
    Last Post: 06-11-2019, 03:35 AM
  2. Check if a time is within two times (using first time as the starting time)
    By CraigsWorld in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 10-13-2017, 05:24 PM
  3. [SOLVED] Random time to regular time
    By allheilyb1 in forum Excel General
    Replies: 3
    Last Post: 10-16-2014, 01:33 PM
  4. Can't sort time data for values ending in '0'
    By Antarctic-Excel in forum Excel General
    Replies: 3
    Last Post: 11-28-2011, 01:39 PM
  5. Never ending time sheet
    By Ltat42a in forum Excel General
    Replies: 14
    Last Post: 11-26-2008, 07:49 AM
  6. Ending application on time macro
    By phil2006 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-21-2008, 06:05 PM
  7. Charts with setting starting and ending point on x (time)
    By yuri in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-24-2008, 08:28 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1