Home |
Search |
Today's Posts |
#1
|
|||
|
|||
filling a cell
I have a worksheet that I use to keep track of my time
spent on projects. right now I just enter the time in manually and have formulas to add up the time. I just added a cell that lists the current time using =now(). What I'm wondering how to do is this: Can I click on a cell and get the current time put into it automatically? TIA |
#2
|
|||
|
|||
any cell
<cntrl<shift<; Regards Bill K "Terry" wrote in message ... I have a worksheet that I use to keep track of my time spent on projects. right now I just enter the time in manually and have formulas to add up the time. I just added a cell that lists the current time using =now(). What I'm wondering how to do is this: Can I click on a cell and get the current time put into it automatically? TIA |
#3
|
|||
|
|||
Awesome. thanks alot
-----Original Message----- any cell <cntrl<shift<; Regards Bill K "Terry" wrote in message ... I have a worksheet that I use to keep track of my time spent on projects. right now I just enter the time in manually and have formulas to add up the time. I just added a cell that lists the current time using =now(). What I'm wondering how to do is this: Can I click on a cell and get the current time put into it automatically? TIA . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
filling a cell | Excel Discussion (Misc queries) | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions | |||
VLookup resulting in a blank cell... | Excel Worksheet Functions |