To extract the seconds from the time entered in cell B1 as 12:00:52 PM, type =SECOND(B1) in cell C1 and press ENTER.