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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top