While Microsoft Excel automatically reformats time values as hours and minutes, you can manually change the cell's time format to display the seconds as well.

How to Round the Minutes in Excel Worksheets. Excel's ability to add and subtract time values makes it a powerful tool for tracking data that involves hours and minutes. But if you want to round ...

To display specific values in a PivotTable in Microsoft Excel, use one of the many built-in filters, such as Top 10.