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


complete excel tutorial pdfwriting macros for excelvba userformmicrosoft word add developer tab to ribbonsql commands pptproject dashboard templates excelcolor formula in excel 2007cool excel chartscalculating force worksheetmacros excel 2007vba repeatmacro code for excelbasic excel macrosnested if and statements in excel 2010excel vba programming for beginnersmicrosoft dashboard templatesexcel vba message box yes nodashboard excel examplesvba code in excel examplesexample of vlookup in excel 2010vba create pdfvb dirdml and ddl queriesmerging excelhide formulas in excel 2007vba current celllearn to code vbaexcel macro filterif statements excellexcel lookup functionsremove duplicate names in excelexcel macro read text fileprocedure writing worksheetsas tutorial ppthow to merge three columns in exceldelete duplicate recordsvba excel hyperlinkvba formatconcatenate function excelunprotect excel sheet vbaexcel vba application gotowhat is the sumif function in excelvba programming for beginnersexcel sort macroexcel vba save as pdfhighlight duplicates in excel 2007costing templatevba access open forminsert comment in excelunprotect excel onlinehow to insert check mark in excel 2007format cells vbavba open file for inputvba excel dialog boxdelete duplicate excelinserting multiple rows in excelvba sql querysas guide for beginnersiferror function excelvisual basic for macros in excelhow to find and delete duplicates in excelsample excel dashboardsvbscript excel saveassql interview questions and answers pdf downloadinput in vbainsert a check box in excelexcel vba and macroshow to delete duplicate data in excelexcel vba set cell colorwhat is col index num in vlookuprange.autofilterhow to prepare dashboard in excel 2007excel hyperlink to filevba dim variable