![]() |
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 |
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 |
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