Search results

Hi Narayan, While B-F... contain data, there is not data in each row of each column based on col A being sorted in time order. The result of time difference is now in the blank merged sections of each individual column. I have been doing it individually (sometimes thousands of rows !$#?). I...

Yes, date & time are both in column A dumped from another program, so it does also include seconds. The other times is the duration between the data collection times represented as "data". The actual data is irrelevant, as it is to monitor a frequency of the collection. So, B5:B11, 0:34:18...

Hi, Looking for a formula to show time lapse based on a cell above and below where the data is entered. The date/time is always in column A, but the row is ever-changing (time). Example: Data in B4 & B12. B5:B11 is where the value of time lapse from corresponding time in column A4 & A12...

Thanks for the great welcome with a PERFECT (and quick!) solve. :)

That is so cool. Any way to pull the range of the month and person's name as to not use separate cells for entry/reference? Thanks for your help, I enjoy reading your work!

Hi all! I am trying to figure out the best formula to get a monthly result (in %) of "OK"s per person listed on my spreadsheet.: Date Name RT1 RT2 RT3 1/1/2013 John c ok ok 1/3/2013 John ok b ok 1/3/2013 Mary ok ok ok 1/4/2013 Mary d ok e 1/4/2013 Sue a d ok 2/6/2013 John ok ok ok...