Using TODAY function to calculate a half life


I am trying to use the TODAY function to continuously track half-lives of different radioactive material for inventory purposes. For example, if I order 50 mCi of lead 203 which has a half life of 51.8 hours, how can I make a formula to check how much has decayed in two days? Basically, is there a way to make the TODAY function not only track the date, but also any given time of the day?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!