• Home
  • VBA Tutorial
  • VBA Cheat Sheet
  • Excel SQL Add-In
  • VBA Time Saver
  • VBA Web Scraping Kit
  • Excel LOOKUP Wizard
  • Merch

Analyst Cave

Simply the best place to learn Excel and Analytics

  • vba basics and beginnerVBA Basics
    • The Developer Tab
    • Record Macro
    • Debugging VBA
    • VBA Subs & Functions
    • VBA Variables
    • If…Then…Else Conditions
    • For Loops
    • Do While, Do Until loops
    • Error Handling
  • vba object and classVBA Objects
    • VBA Class
    • VBA Type
    • VBA Enum
    • VBA Array
    • VBA Collection
    • VBA Dictionary
    • VBA ArrayList
    • VBA Queue
    • VBA Stack
    • VBA Implements
  • vba functionsVBA Functions
    • VBA Array Functions
    • VBA Conversion
    • VBA File Functions
    • VBA Date Functions
    • VBA String Functions
  • vba fileVBA Files
    • File Dialogs
    • FileSystemObject
    • VBA Read Files
    • VBA Write Files
    • VBA Directory
    • VBA Delete File
    • Traverse Folders
    • XML Files
    • Merge Excel files
    • VBA Download File
    • VBA FTP
  • vba stringVBA Strings
    • VBA Regex
    • VBA Like
    • Searching Strings
    • Substrings
    • Find/Search Strings
  • vba forms and dialogsVBA Forms
    • Message Box
    • VBA UserForms
    • VBA InputBox
    • VBA Progress Bar
  • vba for excelVBA for Excel
    • VBA Range
      • Used Range, Last Cols/Rows
      • AutoFit Rows & Columns
    • VBA Cells Formatting
    • Worksheets
    • ListBox Control
  • vba keyboard shortcutKey Shortcuts
  • excel vba booksExcel VBA Books
  • excel video coursesVBA Video
  • vba basics and beginnerVBA Basics
    • The Developer Tab
    • Record Macro
    • Debugging VBA
    • VBA Subs & Functions
    • VBA Variables
    • If…Then…Else Conditions
    • For Loops
    • Do While, Do Until loops
    • Error Handling
  • vba object and classVBA Objects
    • VBA Class
    • VBA Type
    • VBA Enum
    • VBA Array
    • VBA Collection
    • VBA Dictionary
    • VBA ArrayList
    • VBA Queue
    • VBA Stack
    • VBA Implements
  • vba functionsVBA Functions
    • VBA Array Functions
    • VBA Conversion
    • VBA File Functions
    • VBA Date Functions
    • VBA String Functions
  • vba fileVBA Files
    • File Dialogs
    • FileSystemObject
    • VBA Read Files
    • VBA Write Files
    • VBA Directory
    • VBA Delete File
    • Traverse Folders
    • XML Files
    • Merge Excel files
    • VBA Download File
    • VBA FTP
  • vba stringVBA Strings
    • VBA Regex
    • VBA Like
    • Searching Strings
    • Substrings
    • Find/Search Strings
  • vba forms and dialogsVBA Forms
    • Message Box
    • VBA UserForms
    • VBA InputBox
    • VBA Progress Bar
  • vba for excelVBA for Excel
    • VBA Range
      • Used Range, Last Cols/Rows
      • AutoFit Rows & Columns
    • VBA Cells Formatting
    • Worksheets
    • ListBox Control
  • vba keyboard shortcutKey Shortcuts
  • excel vba booksExcel VBA Books
  • excel video coursesVBA Video

Home » VBA Function – Reference of VBA Functions » VBA Date Functions » VBA Second

VBA Second

The VBA Second Function in VBA returns the number of Seconds remainder of a Date variable provided.

Debug.Print Second("18:01:02")
'Result: 2
VBA Reference – Date Time functions
  • VBA Date
  • VBA DateAdd
  • VBA DateDiff
  • VBA DatePart
  • VBA DateSerial
  • VBA DateValue
  • VBA Day
  • VBA Hour
  • VBA Minute
  • VBA Month
  • VBA MonthName
  • VBA Now
  • VBA Second
  • VBA Time
  • VBA Timer
  • VBA TimeSerial
  • VBA TimeValue
  • VBA Weekday
  • VBA WeekdayName
  • VBA Year

Download VBA Time Saver

VBA Time Saver Kit

Ready VBA Code snippets for Arrays, Strings, File Dialogs, Read/Write Files, Timers, Progress Bar

Download LOOKUP Wizard

Excel Lookup Wizard Book1

Lookup data from external Excel files and worksheets with the Excel LOOKUP Wizard AddIn!

Articles