offers Excel lesson videos made simple!

Sign up or log in to Magoosh Excel.

An Overview of Excel Time Functions

Microsoft Excel is a spreadsheet program developed by Microsoft for platforms like Windows, Mac OS, Android and iOS. It presents calculations, graphs, pivot tables, and macros. It contains functions for performing various calculations like: If, Sum, Date, Time, etc. Here, we will present an overview of Excel time functions.

What Is the Purpose of Using Excel Time Functions?

The Excel time function is an inbuilt function that allows the user to create components of time: hours, minutes, and seconds. This function can be embedded within another function when you need to display accurate time.

excel time functions - magoosh

What Value Does the Function Return?

We all know that mathematical functions return some values. Excel time function is no exception, and it returns a value in decimals which indicates specific time.

What Is the Syntax of Excel Time Functions?

Every function in Excel starts with an “equal to” sign, then the name of the function, followed by a pair of brackets containing parameters. According to this format, the syntax of the time function is:

      “= TIME (hour, minute, second)

Obviously, here the hour represents the hour for the time you want to generate, as does the minute and second.

Some Important Notes

  • The time function is not only used to create time but also to create dates. This date appears in serial numbers with components hour, minute, and second determined by the user.
  • In order to generate a valid time, you have to provide the parameters distinctly (i.e. hours, minutes, and seconds). Once a valid time is generated it can be formatted in any desired way.

Usage of Excel Time Functions

  1. Adding hours in decimals to time: We know one method to add decimal hours to time, which is by dividing hours by 24. Another method is using the time function.

    Let’s consider an example of adding decimal hours to the time using the time function. As shown in the image of Excel workbook page below, time is mentioned in column A, hours to be added are mentioned in column B, and output in C. To add decimal hours to time using time function, the formula is:

        “=A3+Time (B3,0,0)”

  2. Adding decimal minutes to time: Decimal minutes can be added to time by dividing minutes by 1440 or this can be done by using Excel time function. Let’s consider an example.
     
    As shown in the image of Excel workbook page below, time is mentioned in column A, minutes to be added are mentioned in column B and output in C. To add decimal minutes to time using the time function, the formula is:

        “=A3+Time (0,B3,0)”

In this way, the Excel time function is very useful when it comes to any calculations related to time and date. So learn its format, make use of it precisely by providing valid parameters to generate the exact time.

Comments are closed.


Magoosh blog comment policy: To create the best experience for our readers, we will only approve comments that are relevant to the article, general enough to be helpful to other students, concise, and well-written! 😄 Due to the high volume of comments across all of our blogs, we cannot promise that all comments will receive responses from our instructors.

We highly encourage students to help each other out and respond to other students' comments if you can!

If you are a Premium Magoosh student and would like more personalized service from our instructors, you can use the Help tab on the Magoosh dashboard. Thanks!