Time date stamp with out vba

[dubiousp]

Im wrinting a small sheet that will run on phone (android) so VBA is not really an option attached are a couple of sheets,, essentially on the details sheet I need the time date to stay static along with call time... The GCS sheet as the say the eye opwning filed chages I want the time stamp

I have sort of named text =ts =ds but these whilst they work manually I cannot get them to function as a formula for example using if

 

[Joe4]

It gets tricky to accomplish this without the use of VBA.
See here: http://www.howtoexcelatexcel.com/excel-tips-tricks/create-a-timestamp-in-excel-with-formulas/