Static Time in Excel

[Graham C1600]

Hi all,

Hopefully a quick simple issue to be assisted with. Basically I have a spreadsheet where tasks get done and I use Data Validation to check whether the task is 'In Progress' or 'Complete'. I also need to input the start time and finish times on the spreadsheet. What I want to happen is when I use the drop down menu in Cell A1 and change that to 'In Progres's, Cell A2 will have the current time (this time cannot change). Then when I change Cell A1 again to 'Complete', Cell A3 needs the current time. I could attach a simple spreadsheet wioth this on but there would be nothing to view really.

So basically I need to track when a task has started and a task has finished so I can check tiings later.

Thanks

 

[etaf]

have a look at timestamp

https://howtoexcelatexcel.com/blog/create-a-timestamp-in-excel-with-formulas/

 

[Georgiboy]

Not really an answer to the question but did you know the keyboard shortcuts?:
CTRL+: = todays date
CTRL+SHIFT+: = the time now