Can I automatically enter the current date or current time into a

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello everyone and thanks again to the kind people who, for some reason, take
the time to help me through this website.
As indicated in my subject line, it seems to me that there should be an easy
way to do this.
Thank you-
Ben
 
Hi Ben
Your subject line was truncated. I am assuming you wanted date?
=today() will give you the current date.
HTH
 
Ben,

You subject line was truncated, which is a reminder of why you
should always ask your question in the body of the message, not
the subject.

You can enter the current date in a cell with =TODAY().
You can enter the current date and time in a cell with =NOW()

Both of these formulas will update everytime the worksheet is
calculated.

If you want to insert a static date, on that will not change,
press
CTRL+<semi-colon>
Use CTRL+SHIFT+<colon> for the time.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Note that NOW() returns both the Date and Time. If you just want the
time, use MOD(NOW(),1).
 
Hello!

Thanks again everyone for all of the help.
I am essentially trying to make a timesheet. Is it possible to add or
subtract time values?
For example, if I have a starting and ending time entered, is it possible to
calculate the time between?

Thank you.

Ben
 
Just subtract the two cells.

Be aware that if the result is negative and you have
tools|options|calculation tab|1904 date system unchecked, then you'll see:
######.

If you check this option, then you'll be able to see negative times--but this
can be a problem.

If you have dates in that file, they'll have changed by 4 years and one day.
And copying dates between different files (with that option different in both)
is a problem, too.
 
Back
Top