time intervals

  1. F

    Sum Values over 30 minutes for Irregular Time Intervals

    Hello, I have some data that has been recording values every 3 minutes. However due to computer error some of the recordings are taken every 2,4 or even 20 minutes in some cases. The vast majority however are taken over 3 minutes. What I would like to acheive is to be able to record and sum...
  2. D

    Graphing how long it takes to complete a job by the amount of time it takes to perfrom each task

    I am trying to figure out which graph should be used to best represent how long it takes to complete a job with a breakdown of how long each task takes by using the start times from each task to get the time intervas. This will actually be done over multiple stataions. record task1...
  3. F

    Working out interval between dates an times excluding sunday and public holidays.

    Hi, have a spreadsheet that has 2 sets of dates and times on it. I added =(D2-C2) to a column called Interval and that's fine. I have this on another tab that looks at public holidays =(NETWORKDAYS(C2,D2,'Public Holidays'!$B$2:$B$14)) This the next column =D2-C2+1 counts the days, i think...
  4. S

    Adding time if a cell falls between a certain time interval

    I know the formula for adding time which is: +TIME (hours, minutes, seconds). I need to know the formula/code to add TIME to a cell if the cell passes through a fixed time. For example: If cell A1 is 9:00AM and cell A2 is 5:00PM, how do I add 15 minutes to 5:00 to make it 5:15PM without...
  5. E

    How to calculate time intervals between two moments in duration of several days

    Hello.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> I need to calculate the time intervals between two moments in duration of four days. The results in format of [h]:mm then will be used to draw a chart. <o:p></o:p> <o:p></o:p> I am using IF statement...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top