Thanks Pete but I will stick to Toppers solution at this time. Its
doing what I want. One thing that I need now is to lock the column
containing the formula so the user cannot change it . I want the user
to enter the date and time but prevent him from deleting the formula
accidentally.

Thanks and regards