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

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

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

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

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