A to Z of Excel Functions: The SECOND function

Welcome back to our regular A to Z of Excel Functions blog.  Today we look at the SECOND function.

The SECOND function

This function returns the seconds of a time value (expecting a serial number).  The SECOND is given as an integer, ranging from zero [0] to 59.  The SECOND function employs the following syntax to operate:

The SECOND function has the following argument:

• serial_number: this is required and represents the time that contains the seconds you want to find.  Times may be entered as text strings within quotation marks (e.g. "6:45 PM"), as decimal numbers (for example, 0.78125, which represents 6:45 PM, or as results of other formulas or functions (for example, TIMEVALUE("6:45 PM")).

It should be further noted that:

• time values are a portion of a date value and are represented by a decimal number (e.g. 12:00 PM is represented as 0.5 because it is half of a day).

Please see my example below: 

We’ll continue our A to Z of Excel Functions soon.  Keep checking back – there’s a new blog post every business day.

A full page of the function articles can be found here.