• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

TIME in Excel

September 7, 2021 by Andrew Childress
Time in Excel

As you work in Excel spreadsheets, you may find yourself using a variety of different units. Let's learn how to use TIME in Microsoft Excel.

As you work in Excel spreadsheets, you may find yourself using a variety of different units. These might include hours, minutes, and seconds. Now, imagine that you want to combine these elements into a single cell with a time value inside. Fortunately, Excel offers an easy way to do just that. Let’s learn how to use TIME in Microsoft Excel.

How to Use TIME in Excel

Consider three cells containing the values 18,40, and 23. Initially, these may seem to have little meaning, but now imagine that they’re hours, minutes, and seconds. Wouldn’t it be nice to display these values as 6:40:23 PM inside a single cell? Excel’s TIME function lets you do it.

Begin by clicking into an empty cell. For best results, it helps to select Time from the Cell Format dropdown, found on Excel’s Home tab.

Then, input your TIME function:

=TIME(

Now, click into the cell containing the hour. Here, that’s cell A2. Then, type a comma, and select the minute cell, B2. Add another comma, then select the second cell, C2. Close the parentheses, completing your formula as follows:

=TIME(A2,B2,C2)

Time in Excel

Hit Enter on your keyboard, and Excel will return the time value, displayed as 6:40:23 PM.

Time formula in Excel

Now, imagine a second set of numbers: 5, -20, and 10. The time formula here would be:

=TIME(A3,B3,C3)

Since the minute value is negative, Excel will subtract it from the hour. In other words, 5:00 AM, less 20 minutes, is 4:40:10 AM. This demonstrates the versatility of the TIME function.

Time function in Excel

As you can see, Excel’s TIME function takes separate hour, minute, and second values and combines them into a simple, easy-to-read time format. Try it out next time you’re working with sets of time data inside Microsoft Excel.

Category: Excel FormulasTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Show all notesAdd Notes in Excel
Next Post:DOLLAR in ExcelDollar function in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top