*PROVIDING ACCURATE, RELIABLE AND STRAIGHT TO THE POINT KNOWLEDGE ABOUT DIFFERENT IT TOOLS EXPLAINED WITH PRACTICAL EXAMPLES*

#### CONTENTS

# EXCEL FUNCTION-TIME

## INTRODUCTION

*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

### DATA SAMPLE

EXAMPLE | HOUR, MIN, SECONDS |

1 | 10,15,49 |

2 | 12,54,41 |

3 | 26,42,12 |

4 | 23,87,98 |

### STEPS TO USE TIME FUNCTION

=TIME(12,54,41) for Example 2

## CONFUSION CLARIFICATIONS

### 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

YOU MAY LIKE

- EXCEL-FUNCTION-WORKDAY
- EXCEL-FUNCTION-RANDBETWEEN
- EXCEL-FUNCTION-SUMIF
- FOR MORE ARTICLES, CLICK EXCEL OR TYPE IN SEARCH BELOW.