TIME Function in Excel

Home/Excel Formulas/TIME Function in Excel

What is the use of TIME function?

Returns the number that represents the particular time

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 TIME function?

TIME-SYN

TIME(hour, minute, second)

Where
hour: It is a number from 0 to 23 representing the hour
minute: It is a number from 0 t0 59 representing the minute
second: It is a number from 0 to 59 representing the second

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

LIMITED TIME OFFER
By |April 27th, 2013|Excel Formulas|0 Comments

About the Author:

PNRao is a passionate business analyst and having close to 10 years of experience in Data Mining, Data Analysis and Application Development. This blog is his passion to learn new skills and share his knowledge to make you expertise in Data Analysis (Excel, VBA, SQL, SAS, Statistical Methods, Market Research Methodologies and Data Analysis Techniques).

Leave A Comment


Related pages


excel macro find last rowexcel vba select rangemicrosoft excel vba referencevba application transposeadvanced if statements in exceldelete rows in excelrange in vba excelconditional if statements in excelms access insert into vbasumif example excel 2010sas and sqlhow to copy cells in excelmicrosoft office project management templatesformula to delete blank rows in excelhow to insert developer tab in excel 2010descending order dates examplehow to combine sheets in excelselect range vbahow to use sumif function in excel 2010sql quiz for interviewvba calculation manualcombine columns in excel 2007shortcut key to insert a row in excelpowerpoint dashboard examplesexcel chart add onsactive range vbaexcel ctrl endexcel hide columns based on cell valueexcel macro merge cellsvba userform controlsdashboard formats in excelexcel query databaserange activecellvba ms access tutorialconditional logic excelexcel advanced vbacreate excel vbawhile loops in vbamicrosoft excel quick keyscreate userform exceldeclare global variable vbaremove duplicates from column in excelexcel vba for stephow to connect excel to sqlhow to unhide rows and columns in excelsyntax in excelidentify duplicates excelexcel vba fill colorexcel dimexcel templates gantt charthow to open excel vbacsv converter to excelcase vba accessvba sortingconcatenate formula in excelrept excelsql manipulation commandsaccess vba close databaseuserform closeprogram in vbahow do you combine multiple excel worksheets into onevba excel open text filevba lookuphighlight duplicate excelunhide cellsvba collection of objectsvba excel stringnested if in vbaexcel combine data from multiple sheetsvba excel lookupbuttons vbasql basics commands