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
Check out the Formula Handbook template!