Hello everyone. I've created a delivery sheet to keep track of the Invoice No. Customer Name and time of delivery. I am having problems to solve the NOW() function. I first used this function and I thought it was great until I noticed that the time always changed to current time every time I used the work sheet which was every 10 to 15 minutes. Here is the formula I put together which is good if you want the current time =IF(A10=1,NOW(),"") HOWEVER what I need is when I type in " 1 " in A10 I want to show the current time in H10 but to hold that time and not change. Is this possible, any help would be great. Thank you all for now Carlo.