ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   New Users to Excel (https://www.excelbanter.com/new-users-excel/)
-   -   filling a cell (https://www.excelbanter.com/new-users-excel/13267-filling-cell.html)

Terry

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

Bill Kuunders

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




Terry

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



.



All times are GMT +1. The time now is 05:30 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com