How do I ...

  • Thread starter Thread starter az-willie
  • Start date Start date
A

az-willie

How do I insert the current time in a cell?

I found how to insert the date but I can't find how to insert the
current time. The NOW function inserts the date and time but it changes
to the current time whenever the spreadsheet is open. I got a clock and
a watch for that. I want to put in the time when I use an inhaler and I
don't want it to change.

Hopefully there is a way to do this.
 
Ctrl + colon or Ctrl + Shift & semicolon
Basically do as with dates but hold down shift key as well
 
Peo Sjoblom said on 1/22/2004 11:56 AM:
Ctrl + colon or Ctrl + Shift & semicolon
Basically do as with dates but hold down shift key as well
Click to expand...

=========
Thank you thank you.

It is Cntrl + Shift + semicolon

I don't know why they make it so hard to find simple things like this.

I looked through the help in excel 2003 and couldn't find this. Maybe
I'm just stupid.
 
willie

Not stupid, just have to know what keyword(s) to enter in your search through
Help.

Help>Answer Wizard "shortcut keys"(no quotes) should give you most of what you
need to know.

OR download Chip Pearson's workbook with the shortcut keys outlined.

http://www.cpearson.com/excel/ShortCuts.htm

Gord Dibben Excel MVP
 
Gord Dibben said on 1/22/2004 2:52 PM:
willie

Not stupid, just have to know what keyword(s) to enter in your search through
Help.

Help>Answer Wizard "shortcut keys"(no quotes) should give you most of what you
need to know.

OR download Chip Pearson's workbook with the shortcut keys outlined.

http://www.cpearson.com/excel/ShortCuts.htm

Gord Dibben Excel MVP
Click to expand...
========
Thanks for the link to the shortcut file. I downloaded them and will
check them out.
 
Back
Top