I am designing a SharePoint data sheet list for recording entry and exit times.
I am using the [Created] column to show the entry time,
a second column called [Out] with a Yes/No choice
and a 3rd calculated column [Time Out] with a formula
This works fine until you add data into other columns then the [Time Out] column keeps on changing time.
How can I make the [Time Out] column only show the time when the [Out] column changes to yes and keep that time, i.e. change from formula to text?