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

In this tutorial, I’ll show you an easy method to report the first and last times from a timestamp in Excel using a PivotTable. We’ll work with the same data from the earlier article.