I have 5 months worth of data that I am trying to find out how many Defects occur within 30, 60, or more than 60 minutes after the defect code 15R occurs.
- Column AX, and AY converted column T and U to integers so that Excel would recognize the imported date and time.
- Column F is used to put the Date and Time into one column (per the suggestion below).
- Row 4 shows the formulas that are used currently.
- Columns C, D, and E were manually updated in the image below but I am looking for a formula so that I do not have to rely on my personal accuracy.
(I pasted in an image because when I go to copy/paste in the worksheet the formatting does not look correct)