Hi guys, a very amatuer user of excel trying to learn on the fly. I am trying to put a form together for work purposes. I have attached a picture of the spreadsheet with the are I am trying to set up. I want to try and organise the cells and a button to do as follows.

1: On opening the file the date is automatically inserted, this I have managed to do. What I need to do is auto insert the date when the file is opened but lock the date on the saved file.

2: I want to set up a button so when you click into the start and end date you push the button and it gives the current time.

These forms are being used on tablets so the less typing you need to do the better.



excel help.jpg