By SCTo extract Hours ,Minutes and seconds from given time these formulas are used.
HOUR Formula in Excel:
It will return the hour as number from 0 to 23.Zero for 12 AM and 23 for 11 PM .
MINUTE Formula in Excel:
It will return the minute as number from 0 to 59.
SECOND Formula in Excel:
It will return the second as number from 0 to 59.
As visible in image above HOUR ,MINUTE&SECOND will extract hour ,minute and second part from given time.