+ Reply to Thread
Results 1 to 3 of 3

StartTime for new date at 8PM rather than 12AM

  1. #1
    Registered User
    Join Date
    10-03-2014
    Location
    earth
    MS-Off Ver
    2010
    Posts
    11

    StartTime for new date at 8PM rather than 12AM

    This is a continuation of this problem.
    http://www.excelforum.com/excel-form...ml#post3855182

    We figure out the solution, but the result isn't accurate.

    Normally, from what I understand, time is associated with 12AM = .00, and 11:59pm = .9999
    The starttime for the new date is 12am, but I would like to change that. Our ACTUAL start time is actually 8PM to 7:59pm.

    We are =percentile.inc() to figure out how much of 95% of all event has been done at this time, but again, because we associate 12AM with our start time, it is giving us false information. We need it to be at 8PM. 8PM to 7:59PM is consider Day 1.

    Anyone got a clue?

  2. #2
    Registered User
    Join Date
    10-03-2014
    Location
    earth
    MS-Off Ver
    2010
    Posts
    11

    Changing the start point of =TimeValue...somewhat?

    To clarify it somewhat,

    =timevalue function returns a decimal number of time represented by the text string. 12:00 is .00, 11:59 is .9998, etc.

    I would like to change it so 8PM is .000 and 7.59Pm is .9998.

    Our event happens at 8:00pm as this is non-production hour, and go through the day and ending again at 7:59pm (next day).

    We need to figure out at what percentile that we can tell our customers that we are 95% of the time finished by. But because some events happen at 9:00pm, it's counted as .888 rather than .1.
    Last edited by samuez; 10-16-2014 at 07:42 PM.

  3. #3
    Registered User
    Join Date
    10-03-2014
    Location
    earth
    MS-Off Ver
    2010
    Posts
    11

    Re: Changing the start point of =TimeValue...somewhat?

    Book1.xlsx

    here's a short excel that I'm trying to solve and the problem that I got.

+ 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] Create chronological starttime timesheet from a schedule that returns name from same row
    By chris_kanuka in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-05-2014, 03:06 PM
  2. [SOLVED] extract hours that meet conditions from timeframe (starttime and endtime)
    By DirkBekkers in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 02-27-2013, 09:35 AM
  3. Only one bold gridline at 12AM
    By xitvp in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-15-2008, 10:24 AM
  4. get Automatically Refreshing Data at 12am
    By AKorsakova@gmail.com in forum Excel General
    Replies: 0
    Last Post: 05-16-2006, 08:35 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