The Excel Time Function


The Excel Time Function – What its use for? The Excel Time function is to display the time in a cell.

Excel allows you to manipulate dates and times and perform calculations on them. If you type a date or time (e.g. 13/3/08 or 9:28) directly into a cell Excel should recognise it as such. The program will normally align it to the right of the cell and display it in the formula bar in a standard format (e.g. 13/03/2008 or 9:28:00 AM).

The TIME Function Syntax:
TIME (Hour, Minute, Second)

Hour is a number from 0 (zero) to 23 representing the hour.Minute is a number from 0 to 59 representing the minute.Second is a number from 0 to 59 representing the second.

Examples:
TIME(12, 0, 0) is equivalent to 12:00:00 p.m.
TIME(16, 48, 10) is equivalent to 4:48:10 p.m.


To add and subtract times

  • To add 1 hour, 35 minutes, 10 seconds to a time in A1, use the function =A1 + TIME(1,35,10)
  • To subtract 1 hour, 35 minutes, 10 seconds from a time in A1, use the function =A1 - TIME(1,35,10)

    Note: You can add times using the =SUM worksheet function. Just enter all of your times as HH:MM:SS, and then use SUM function to add them up.

    The Excel Date Function


    In Excel, the Date Function is to display the date in a cell.

    To display the current time or date in a cell, use the NOW() function. Just type =NOW() in the cell and it will display the current data and time.

    The DATE Function Syntax:
    DATE (Year, Month, Day)

    To add and subtract dates

  • In the cell A1, type a date such as 1/2/08.
  • In cell A2, if you wish to add 8 days to cell A1, use =A1+9, which gives 9/2/08.
  • In cell A3, if you wish to subtract 5 days to cell A1, use =A1-5, which gives 4/1/08.

    Get FREE ebooks!
    (Click for more info)

    Subscribe to...
    MS Office Tips Newsletter

    E-mail Address:
    First Name:
    Then

    Don't worry -- your e-mail address is totally secure.
    I promise to use it only to send you MS Office Tips.

    Can't find what you're looking for? Try Google Search!

    Google
     

    Back to Top


    >> Next Topic : Adding and Customizing Excel Comments

    << Previous Topic : How to Create the Excel Drop Down List Menu?


    You're viewing the Excel time function info page, click here to go back to the Home Page