Entering Dates And Time In Excel


Q. Is there a quick way to enter dates and times in an Excel spreadsheet?

A. To enter the current date, select a cell and press Ctrl+; (that’s Ctrl and then the semicolon). To enter the current time, use Ctrl+: (the colon).

These shortcuts work even when you are entering formulas. For instance, let’s say you wanted to have today’s date as a string (within quote marks) in a formula. Enter your formula, up to the first quote mark, type Ctrl+; and the date appears in the formula. Type your closing quote mark, and continue with your formula.

However, if you’re going to use the time shortcut, be sure the internal clock on your computer is correct, because they are notorious for losing or gaining time. I once had a nifty little program that measured the drift error rate and then automatically corrected the time whenever I booted up. Unfortunately, I accidentally left that application behind in a discarded computer and haven’t been able to replace it. If anyone knows of a similar program, please let me know and I’ll share it in this column.

To obtain the exact time in your time zone, go to www.time.gov/timezone .

If you want to automatically synchronize the exact time with your computer’s internal clock, go to http://winfiles.cnet.com/apps/98/clock.html . The site contains many shareware and freeware programs that do the job.

SPONSORED REPORT

How the election may affect taxation of business income

This report summarizes recent proposals to reform the U.S. business income tax system and considers the path to enactment of any such legislation.

VIDEO

How to Excel pivot a general ledger

The general ledger is a vast historical data archive of your company's financial activities, including revenue, expenses, adjustments, and account balances. J. Carlton Collins, CPA, shows how to prepare data for, and mine data with, PivotTables.

QUIZ

Did you follow 2016’s biggest accounting news?

CPAs will remember 2016 as a year of new standards and new faces. How well did you follow the biggest accounting events? The 7 questions in this quiz will help you find out