ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Time Function (https://www.excelbanter.com/excel-discussion-misc-queries/29117-time-function.html)

Donovan

Time Function
 
Is there a function that allows you to automatically enter the time of day in
a cell based other information being entered in another cell (IF..Then) and
not have the time automatically updated every time you open the spreadsheet?

JE McGimpsey

Take a look he

http://www.mcgimpsey.com/excel/timestamp.html


In article ,
"Donovan" wrote:

Is there a function that allows you to automatically enter the time of day in
a cell based other information being entered in another cell (IF..Then) and
not have the time automatically updated every time you open the spreadsheet?


donovan



"JE McGimpsey" wrote:

Take a look he
That worked great. Thanks...


http://www.mcgimpsey.com/excel/timestamp.html


In article ,
"Donovan" wrote:

Is there a function that allows you to automatically enter the time of day in
a cell based other information being entered in another cell (IF..Then) and
not have the time automatically updated every time you open the spreadsheet?




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

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