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 tutorial charts and graphshow do you protect an excel spreadsheetsample excel test for interviewvba xlsexcel how to delete blank rowsexamples of vlookupexcel 2013 merge cellssimple v lookupmonthly gantt chart excel templateworkbook save vbamicrosoft word 2010 assessment test answershow to unlock a password protected excel filevba macrosexcel vba propertyfso deletefilevba createtextfileaccess vba caseexcel vba isnaexcel comparison operatorsvb adovba insert rowsms access vba msgboxvlookup vba exampleadodb connection openremove empty rows excelexcel macro buttonsrecordset sqldrop down macro excelvlookup explainedcopy paste vbadownload adodbcreate a userform in excelaverage function excel 2007if iserror vbavba connection string to access databaseremove duplicates in excelmsgbox yes no vbamacro to unlock password protected workbookvba array stringvlookup practiceexcel macro securityvba numberformataccess vba referencevlookup in excel formula with examplerecordset vba excelexcel vba usesfunction of vlookup in excelprotect excel formulasvba line feed characterlistbox multiselect vbaexcel vba delete duplicate rowsglobal variable vbaaccess vba rgb color codesadodb referencehow to merge tabs in excellistbox selecteditemshow to change excel row to columnexcel vba cell offsetpastespecialhow to copy entire row in excelhow to enable macros in excel sheetvba message boxexcel case statementproject management sheet excelmessagebox buttonsvba excel tutorialexcel macro countifexcel macro option buttonexcel password protect vbaexcel macro vbacreate pivot table in excel 2007vba userform checkboxexcel remove rows containingexcel vba goto labelsumif function in accesswhat does it mean to merge cellsmacro to close workbook