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.

RESOURCES

Keeping you informed and prepared amid the coronavirus crisis

We’re gathering the latest news stories along with relevant columns, tips, podcasts, and videos on this page, along with curated items from our archives to help with uncertainty and disruption.

SPONSORED REPORT

Getting leases in line

ASC Topic 842 is a relatively simple standard that can mean profound changes for organizations with leases. This report examines what makes this standard challenging and describes new ways for CPAs to add value.