The SECOND function returns an integer representing the seconds component of a supplied Excel time.




Argument Description
serial_number A valid time from which you want to extract the seconds component.
  • Times can be supplied as text (e.g. “7:45 PM”) or as decimal numbers (e.g. 0.5, which equals 12:00 PM).
  • If the serial_number argument contains a date and time, the SECOND function ignores the date part of the argument.


  A B C D
1 Time Formula Result Notes
2 12:10:30 PM =SECOND(A2) 30 Basic usage – only seconds are returned
3 12:10 PM =SECOND(A3) 0 Time contains no seconds
4 7/20/2015 7:30:24 PM =SECOND(A4) 24 Date component is ignored
5 20-Jul-2015 =SECOND(A5) 0 Date contains no time component
6 7:30:24 PM =SECOND(A6) 24 Valid time entered as text

Common Function Error(s)

Problem What went wrong
#VALUE! Occurs if the supplied serial_number is not a valid time