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


columns vba excelexcel chart add insvba direxcel yearly schedule templatesql ddlhighlight a column in excelexcel odbc sql querychart creation in excelexcel macro saveunhide columns in excel 2010macros with excelvlookup examples in excel 2007listbox vbavba excel xmlconstruction cost estimate template excelvba excel cells.findexcel vba clearcontentsconsolidate data from multiple worksheets in a single worksheetexcel vba change cell colorexcel advanced tutorialschange width of column excelvbscript excelbasic excel shortcutscheckbox syntaxpivot tables in excel 2003vba inputboxexcel hiding columnsvba tipssave vbaexcel pie chart exampleexcel 2007 hide ribbonit business analyst interview questions and answers pdfworksheet function vbalistbox rowsource vbawhat is the vlookup function in excelall shortcut keys of excel 2007technical questions for freshers interviewvba application calculationhow to unprotect an excel spreadsheetvba delete entire rowexcel spreadsheet templates for project managementtask excel templatevba unprotectiferror vlookup excelinsert comment in excelcolor code worksheetsexcel option explicitms word macros examplesvlookup function examplesexcel vba cut and paste rangevba excel redim preserveinsert button excel 2007greater than and less than formula in excelunhide a sheet in excelremove duplicates from excel spreadsheetunprotect excel workbook vbasql interview questions for beginnershow to automate graphs in excelexcel macro remove duplicatesmacro active cellexcel vba lookup valuevba learningexcel multiple if conditionsvba listbox valuedevelopers tab excelhow to set macro security in excel 2010how to dynamically change excel chart dataexcel csv convertervlookup excel vbaaccess vba open excel fileconsolidated worksheetexcel copy worksheetexcel sort vbalookup function in excel 2007excel vba connect to sql serverhow to check duplicates in excel 2007vba code msgboxvariables in excel vba