Hey guys, Today we will be discussing TIME Function in Microsoft Excel.After going through this article you will be able to understand and implement the TIME Function in your spreadsheet. We will make you understand the concept with the help of example also so that you could implement it practically on your spreadsheet.
What is TIME Function?
Time Function is a very useful function when we need to specify a proper time in other formula or function. Time Function helps in defining the time in decimal format to a specific format containing three arguments as hours, minutes and seconds. TIME Function returns a decimal value lies between 0 and 0.999988426, that actually is represented in hours, minutes and seconds format.
How to use TIME Function in Excel?
Syntax for TIME Function:
=TIME( hour, minute, second )
- hour: It represents the hour value of the Time, that is an integer number.
- minute: It is also an integer value, where we define the minute value of TIME.
- second: All three arguments of TIME Function are mandatory.Here, also we specify an integer value.Any number greater than 59 turns into minutes.
Let’s do an example and understand how can we implement TIME Function practically.
Consider this spreadsheet,
Here we have tried to define the different set of values to get the effects in results. Let’s write TIME Function step by step to understand it practically.
Writing TIME Function:
- hour: We have defined some integer values in “hour” column.
- minute: In the minute column, we have tried to define some zeroes as well with positive integer values.
- second: We have defined some negative values with zeroes in “second” column to see the effects of results with the different set of numbers.
As we can see above, we have taken the different set of data, to test the results of TIME Function.
When we have defined, minute and second values in the first entry, we see the results as “8:00:00 AM” and when we have specified a negative value in “second” column, that is safely taken by the TIME Function and a shift by one in the hour and minute values can be seen and we get results as 11:59:59 PM.And In the last entry, where we have defined minute value as 75, it rolled over and 60+15 minutes turns into 1 hour 15 minutes and hence given the result as 7:15:00 AM.
So, This is How you can use Excel’s Time Function efficiently. As described above Time function is very helpful in defining the time in a proper format, you can use it with other functions and formulas as well. If you really liked this post then you can share it with your friends, colleagues, and relatives. We update these articles on regular basis. You can also share this post on facebook, twitter, Google+ or other social media website. We hope that this article was really helpful to you. If you have any query regarding this post you can freely write in the comment section and We’ll revert back to you as soon as possible.