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.
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 timesTo 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 datesIn 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.
Can't find what you're looking for? Try Google Search!
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