I am a newbie when it comes to excel.I can usually figure out what I need but this one has stumped me. I am not even sure this is possible. Any help would be gratefully appreciated. I am trying to make a conditional input ("y") button to enter an automatic start time =IF(A2="y",NOW(),"") Then I need to manually input a required run time in hh,mm,ss but not be a time of day. Just add the number of hours to the time of day. Then I have a required cool down time before I can run again =IF(A2="y",B2+E2+TIME(8,0,0),"") which is the start time+run time+8 hours and that needs to be compared to current time NOW() and if the total run time+cool down time =NOW() show text "yes","NO"
Now here is my biggest problem.. I have to have multiple lines but every time I put a "y" in to start, it refreshes all NOW() functions. Once I have a start time is it possible to not refresh it again? And how do I make an input box that will just add hours to time of day and not add time of day to time of day.. I have hidden columns that are the decimal times and all my formulas refer to the hidden files for data. Would it be possible to add a real time clock display that would not refresh all NOW() functions also? I have been working on this for a week and I have myself so confused now I don't know what to do anymore. I have a sample sheet I can send someone if it would help.. Thank you so much for your help!!




EggHeadCafe - Software Developer Portal of Choice
Crystal Report And Parameter Passing Using Stored Procedure
http://www.eggheadcafe.com/tutorials...nd-parame.aspx