How to Match Excel Data Recorded at 15-Minute Intervals
Question details
The user needs to match multiple datasets (such as temperature, current, and voltage) that are recorded at 15-minute intervals, or handle mismatched intervals by calculating intermediate values.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Aligning time-series datasets recorded at regular or irregular intervals for accurate cross-parameter analysis.
- Observed behavior
- Data alignment is straightforward when intervals perfectly match, but requires calculated interpolation when intervals differ across datasets.
Ensure that the date and time columns in both datasets are formatted consistently as 'Date/Time' and sort both tables chronologically before attempting to match the records.
Match Data Using Lookup Functions for Identical Intervals
Use this method when both datasets are strictly recorded at matching 15-minute intervals.
When your datasets perfectly align at 15-minute timestamps, you can directly pull matching values from one dataset to another using standard lookup functions like VLOOKUP or INDEX/MATCH.
Select the date and time columns in both datasets, right-click, choose 'Format Cells', and apply the same custom Date/Time format (e.g., 'mm/dd/yyyy hh:mm') to ensure consistency.
If date and time are in separate columns, create a helper column combining them using the simple addition formula =A2+B2 in both sheets.
In your primary dataset, use a formula like =VLOOKUP(C2, Sheet2!C:E, 2, FALSE) or =INDEX(Sheet2!D:D, MATCH(C2, Sheet2!C:C, 0)) to pull the matching temperature or voltage values.

Calculate Intermediate Values using Linear Interpolation
Use this method when one dataset has different intervals and you need to estimate intermediate values before matching.
Align and Interpolate Time-Series Data in WPS Spreadsheet
Easily manage large datasets, match time intervals, and perform complex interpolations using the powerful lookup and statistical functions built into WPS Spreadsheet.
- 1. Import Datasets: Open both of your time-series datasets in WPS Spreadsheet.
- 2. Standardize Time Formats: Select your timestamp columns, press Ctrl+1 to open Format Cells, and align the Date/Time formats.
- 3. Apply Lookup Formulas: Use VLOOKUP or INDEX/MATCH to instantly align identical 15-minute records.
- 4. Interpolate Gaps: For mismatched intervals, utilize WPS Spreadsheet's built-in FORECAST.LINEAR function to accurately estimate missing values.

Frequently Asked Questions
Why does VLOOKUP return #N/A even though the 15-minute timestamps look identical?
This happens due to floating-point precision issues in spreadsheet software where invisible micro-fractions of a second differ. You can wrap your time references in the ROUND function, like =ROUND(A2, 5), to ensure exact matching.
How do I automatically generate a column of sequential 15-minute intervals?
Enter your starting date and time in the first cell. In the next cell down, enter the formula =A2 + TIME(0,15,0). Select that cell and drag the fill handle down to automatically generate continuous 15-minute intervals.
Can I merge datasets with different time intervals without formulas?
Yes, you can use the Consolidate feature or PivotTables to group the data by 15-minute intervals and average the differing inputs, which provides a clean alignment without complex interpolation formulas.
Is linear interpolation accurate enough for temperature data?
For relatively short intervals like 10 to 15 minutes, linear interpolation is generally accurate enough. For highly volatile data or longer gaps, non-linear mathematical modeling might be necessary.




