In this tutorial you will learn how to use time function in excel and why use time function. Time function is one of the built in functions of excel. This is used for representation of time. Time function is write as following.

=TIME(hour,minutes,seconds)

Find time by giving the hours, minutes and seconds. Also can find the time taken by car or persons in race so you can use time function. Today function is used to showing current date in cell. The Today function is write as following.

=TODAY()

use time function in excel example:-

For using time function in excel you have a spread sheet having Driver ID, car, hour, minute, second and calculate time.

spread-sheet-of-car-racing

Now For inserting time function in cell click on formulas menu and visit option named as Date&Time as like following.

time-function

After selection of time function the function arguments dialog box appear like as following.

time-function-arguments

In the hour text box give reference of cell having value of hour. In minute text box give reference of cell having value of minute and same as seconds.

use time function in excel

After clicking on OK button the result is display in cell F2. So time calculated of drive.

time-function-applied

Now copy function for next cells. Select cell and take mouse arrow on right below corner of cell and hold click and drag down mouse. So function is copied to other cells.

use of time function in excel

You also can insert current date in the excel sheet by using TODAY() function. For this add new column named as today date.

use date function in excel

So for inserting current date select TODAY() function from TIME&DATE option.

today-date-function

After selection of TODAY() function dialog box appeared as following.

today-function-dialog-box

Press OK button so current date is displayed.

today-function-applied

Now copy function in other cells by drag the function and function copied.

function-copied-in-other-cells

So time and today functions are applied to the excel spread sheet.

Please follow and like us:

ali hiader

Leave a Reply

Your email address will not be published. Required fields are marked *