How to Use Excel to Interpolate. Interpolation is a powerful tool used to determine values that do not appear within a given set of numbers.

Using three Microsoft Excel functions, you can easily parse time components from a full date value.