How to get different time stamps always without change

[Ratan Bhushan]

Hi Team

I want whenever there is 1 in a cell timestamps come when one enters 1, and when one enters 0 then I want timestamp of change in different cell.

Is there any way to achieve this by formula.

Please help

I have attached sample file.

Thanks
Ratan B

 

[NARAYANK991]

Hi Ratan ,

See if this is OK.

Narayan

 

[Ratan Bhushan]

Hi Ratan ,

See if this is OK.

Narayan

Its just superlike sir...

awesome...