Google sheet Update

in my google sheet some data will change from back end every after 6 hours. i need to updates of time tamp in next cell. also need time left from 6 hours.