View Single Post
  #7   Report Post  
Ben
 
Posts: n/a
Default can I add and subtract time values?

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

"Chip Pearson" wrote:

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





"Ben" wrote in message
...
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