FSTO: I believe this would require a macro vice a formula. Those can get complicated to build, but you could probably find one online.
The issue that this could give you though is the updating of the time. With some formulas, you need to do a refresh to see the response or updated answer. I...