Appearing at a specific time is much more tricky. Methods that involve the formula function
NOW() do not work well because
NOW() can be anywhere from a few minutes to an hour or more off.
If you always want a specific time of day, you can have an automation that runs at that specific time of day and updates the record. It can get tricky to identify that record in the time based automation. It either needs to be the only record that matches conditions, or you need a script. Even so, the time based automations are not always exact (although they are more reliable than