Time Functions in Excel

Monday, 17 June 2013

Time Functions in Excel
There are a number of ways to enter the current time in an Excel spreadsheet. Try this:
Click inside a blank cell on your spreadsheet
Click into the Formula Bar at the top
Type the following inbuilt function:
= Now( )
Hit the enter key, and you'll get the current date and time. If you only want the time, you can format the cell to get rid of the date part:

View Docs

No comments:

Post a Comment