Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Convert text string to valid reference in Excel using Indirect function
  • Last row number in range
  • How to create dynamic named range with OFFSET in Excel
  • Find closest match in Excel
  • INDEX function: Description, Usage, Syntax, Examples and Explanation

Data Analysis Examples

  • How to create a Histogram in Excel
  • Conditional Formatting Rules in Excel
  • How to Create One and Two Variable Data Tables in Excel
  • Get column name from index in Excel Table
  • Working With Tables in Excel

Data Validation Examples

  • Excel Data validation allow weekday only
  • Excel Data validation date in next 30 days
  • Excel Data validation no punctuation
  • Excel Data validation date in specific year
  • Excel Data validation number multiple 100

TIME function: Description, Usage, Syntax, Examples and Explanation

by

What is TIME function in Excel?

TIME function is one of  Date and Time functions in Microsoft Excel that returns the decimal number for a particular time. If the cell format was General before the function was entered, the result is formatted as a date.

The decimal number returned by TIME is a value ranging from 0 (zero) to 0.99988426, representing the times from 0:00:00 (12:00:00 AM) to 23:59:59 (11:59:59 P.M.).

Syntax of TIME function

TIME(hour, minute, second)

The TIME function syntax has the following arguments:

  • Hour: A number from 0 (zero) to 32767 representing the hour. Any value greater than 23 will be divided by 24 and the remainder will be treated as the hour value. For example, TIME(27,0,0) = TIME(3,0,0) = .125 or 3:00 AM.
  • Minute: A number from 0 to 32767 representing the minute. Any value greater than 59 will be converted to hours and minutes. For example, TIME(0,750,0) = TIME(12,30,0) = .520833 or 12:30 PM.
  • Second: A number from 0 to 32767 representing the second. Any value greater than 59 will be converted to hours, minutes, and seconds. For example, TIME(0,0,2000) = TIME(0,33,22) = .023148 or 12:33:20 AM
Worked Example:   Add decimal minutes to time in Excel
Time values are a portion of a date value and represented by a decimal number (for example, 12:00 PM is represented as 0.5 because it is half of a day).

Worked Example:   Convert text timestamp into time in Excel

Example of TIME function

Steps to follow:

1. Open a new Excel worksheet.

2. Copy data in the following table below and paste it in cell A1

Note: For formulas to show results, select them, press F2 key on your keyboard and then press Enter.

Worked Example:   Excel Date & Time Functions Example

You can adjust the column widths to see all the data, if need be.

Hour Minute Second
12
16 48 10
Formula Description Result
=TIME(A2,B2,C2) Decimal part of a day, for the time specified in row 2 (12 hours, 0, minutes, 0 seconds) 0.5
=TIME(A3,B3,C3) Decimal part of a day, for the time specified in row 3 (16 hours, 48 minutes, 10 seconds) 0.7001157

Post navigation

Previous Post:

NOW function: Description, Usage, Syntax, Examples and Explanation

Next Post:

TIMEVALUE function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to get top level domain (TLD) in Excel
  • TEXTJOIN function: Description, Usage, Syntax, Examples and Explanation
  • How to convert numbers to text using TEXT function in Excel
  • LEFT, LEFTB functions: Description, Usage, Syntax, Examples and Explanation
  • UPPER function: Description, Usage, Syntax, Examples and Explanation
  • Calculate total hours that fall between two times in Excel
  • YEARFRAC function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate working days left in month in Excel
  • Get month from date in Excel
  • Generate series of dates by weekends in Excel
  • AMORDEGRC function: Description, Usage, Syntax, Examples and Explanation
  • CUMIPMT function: Description, Usage, Syntax, Examples and Explanation
  • EFFECT function: Description, Usage, Syntax, Examples and Explanation
  • DDB function: Description, Usage, Syntax, Examples and Explanation
  • ODDLPRICE function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles