Formulas > =SECOND()
How To Use SECOND() Function in Google Sheets
Description
How To Actually Use SECOND() in Sheets
SECOND(time)
Try SECOND yourself
In the range B1:B10, enter times in the format HH:MM:SS. Use the SECOND() formula in cell C1 to extract the seconds from the time in B1. Drag the formula down to fill C1:C10.
Hints (2)
-
Make sure the time in B1 is in the correct format.
-
Remember to drag the formula down to apply it to other cells.
Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at BetterSheets.co/formulas
Learn more about the SECOND() formula:
Generate a SECOND() formula for your needs
Describe your task in plain English and get a paste-ready formula that uses SECOND(). 2 free AI generations, no signup. Members get unlimited use.
Generate a SECOND() formula