How to display the seconds value in a specific time,
1. Go to the Formula tab> Select the Date & Time drop down list> Click on SECOND
2. The function argument window will popup
3. In the Serial_number input box enter the required time including seconds
4. I have entered "10:25:31"
5. The resulting value of the seconds within the time is 31.
6. Click on OK
7. The result is now displayed in the active cell of excel
