HOUR Function in Excel

Home/Excel Formulas/HOUR Function in Excel

What is the use of HOUR function?

Returns the hour as a number from 0 to 23

PREMIUM TEMPLATES LIMITED TIME OFFER

ON SALE80% OFF

50+ Project Management Templates Pack
Excel PowerPoint Word

Advanced Project Plan & Portfolio Template
Excel Template

Business Presentations Templates Pack
PowerPoint Slides

20+ Excel Project Management Pack
Excel Templates

20+ PowerPoint Project Management Pack
PowerPoint Templates

10+ MS Word Project Management Pack
Word Templates


What is the syntax of HOUR function?

HOUR Function in Excel syntax

HOUR(Serial_number)

Where Serial_number is the time that contains the hour you want to find.

HOUR Function in Excel – Examples

HOUR Function in Excel Examples

Reference:

Please refer the below article for more Date & Time Excel functions.
Date & Time Excel Formulas

Please refer the below article for more Excel Functions.
Excel Formulas | Home



Related Resource External VBA Reference
Excel VBA Reference Project Management Reference
VBA Reference:
Excel Reference:
By |May 21st, 2013|Excel Formulas|0 Comments

About the Author:

Excel VBA Developer having around 8 years of experience in using Excel and VBA for automating the daily tasks, reports generation and dashboards preparation. Valli is sharing to helps us automating daily tasks.

Leave A Comment


Related pages


advanced excel pivot tablesexcel 2010 stacked bar chartvba code open filehow to lock spreadsheetpassword protect an excel workbookddl sql statementsmerge worksheets exceledit excel macrosmerge 2 columns in excel 2010excel vba vlookup functiondelete blanks in excelvba excel do while loopexcel iserror formulahow to use a sumif formulacost reduction template excelexcel unprotect worksheetexcel all formulas with example 2007chart wizard excel 2007protect cells excel 2007visual basic workbookexamples of excel macrostesting tools interview questions and answers for freshersvba onclickexcel macro delete columnworksheet function in vbahow to extract data from excel sheet to anotherexcel unhide rowshow to insert yes no box in excelvba symbolif iserror vlookup excel 2010vba create new workbookexcel vba replace functionvlookup formula in excelhow to create a drop down box in excel 2007how to enter macro in excelbubble graphs excelcopy excel sheet with formulas to another workbookexcel vba programming for dummies free downloadvlookup in excel exampleshow to insert many rows in excelinterview questions for freshers with answersadd chart title excelhow unprotect excel sheet without passwordvba convertermacro delete rowaptitude test questions and answers for freshers pdfwhat is use of pivot table in excelformula of countif in excelbasics of vbaexcel cost estimate templatehow to create vlookup in excel 2010open a workbook in excel vbafiledialog vbaadvanced excel vba tutorialremove unused cells in excelshow merged cells in excelms excel basics tutorialformatting graphs in excelexcel vba activeworkbook saveasaccess vba open excel workbooksumif excemacros in excel pdfexcel call macroadd developer tab to ribbon in wordhow to use trim function in excelexcel if not blankhow to create activex controlschedule template for excelexcel vba copyfromrecordsetaverageifs in excelvba char function