TIME FUNCTION comes under the DATE AND TIME FUNCTIONS category in Excel.
TIME FUNCTION simply returns the decimal equivalent for a particular time.
The range for the time function is from the 0 seconds i.e. 00:00 [12 am] upto the 0.99988426 that is 23 hrs 59 min 59 seconds.
THIS FUNCTION IS VERY HELPFUL IN MANY TRICKS TO FIND OUT VARIOUS VALUES USING THE DATE AND TIME FUNCTION.
PURPOSE OF TIME FUNCTION IN EXCEL
TIME FUNCTION returns the equivalent decimal number of a particular time.
For example, If we know the hours, minutes and seconds we can find out its decimal number by the use of this function.
It’ll become more clear when we solve the examples later in this article.
PREREQUISITES TO LEARN TIME FUNCTION
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Some information about the HANDLING OF DATE AND TIME BY EXCEL.
- Of course, Excel software.
SYNTAX: TIME FUNCTION
The Syntax for the function is
=TIME(HOUR, MINUTE, SECONDS)
HOUR It is the number of hours. Put the value from 0 to 23.
MINUTE It is the number of minutes. Put the value in between 0 and 59.
SECOND It is the number of seconds. Put the value in between 0 and 59.
Although all the three mentioned arguments can accept the value upto 32767 and it won’t complain by giving you an error but it’ll make some adjustments.
For example, If we give the value of the hours as 27, it’ll divide it by 24 i.e. one day and keep the rest 3 hours as the time.
Similarly if minutes are 61, it’ll divide it by 60 , create one hours and the rest one minute is left.
On the same lines, if we put the seconds as 75, it’ll create one minute and rest 15 seconds are treated as Seconds only.
EXAMPLE:TIME FUNCTION IN EXCEL
|EXAMPLE||HOUR, MIN, SECONDS|
STEPS TO USE TIME FUNCTION
=TIME(12,54,41) for Example 2
DIFFERENCE BETWEEN TIMEVALUE FUNCTION AND TIME FUNCTION
OTHER WAYS TO REACH THIS ARTICLE
DATE FUNCTION, WHAT HAPPENS IF FORMAT IS WRONG IN DATE FORMAT, WHAT IS DATE FUNCTION, HOW TO USE DATE FUNCTION