1. Home
  2. MS Office

Excel 2010: Change Values Into Time (TIME function)

Unlike other spreadsheet programs, Excel 2010 offers a range of functions to automatically deal with all kinds of date and time formats. The Time function takes plain values and show them in time format, letting users easily performs complex operations over time values. UsingĀ TIME function, you can show the values in time format, i.e, hr:min:sec. It requires three arguments to be passed, and automatically determines the military time. Furthermore, it’s capable of detecting (AM) Ante Meridian or (PM) Post Meridian. All you need is to specify the data range i.e. the cell location where values are stored or direct values that you want to convert into TIME format. You can also pick values from different locations and convert them in a single field using the time function. As stated earlier, it automatically detects the values greater than 12 and convert them into military time.

Launch Excel 2010 spreadsheet on which you need to change values into time format. For instance we have included a spreadsheet containing fields; Hrs, Min, and Sec, as shown in the screenshot below.


Now we want to change the values into time format and show it in Time field. The TIME function automatically changes the specified values in hour:Min:Sec format.

The syntax of this function is;


The first argument is hour which refers to Hrs value, next one is minute which refers to Min value and last argument shows seconds.

We will be writhing this formula in Time field as;


B2 in the function is the location of hour value, C2 and D2 refers to minutes and seconds values respectively.


Now you just need to drag the plus sign (located at the right of the cell) towards the end of the cell to apply it over the Time field.


If you want to change the time format, just select the Time field and navigate to Home tab and from Number group, click drop-down button and select More Number Formats.


It will lead you to Format Cells dialog, from Type you can select an appropriate time format from huge list, click OK to continue.

format cell

You will see the time in specified format, as shown in the screenshot below.

time format 1

You can also check out previously reviewed Excel functions; ADDRESS ,FACT (factorial), MAX,MIN, MAXA, MINA and EXACT, Logical Functions, INFO, SUMSQ, DOLLAR, SUMPRODUCT, SUMIF, COUNTIF, VLOOKUP, HLOOKUP ,PMT, & LEN.

Leave a comment