How to calculate time
I hope you are well and safe,
I am working on one project in which I need to check if the time is greater than 24 hrs.
For Example, if the Status is changed to In Progress the created time would be 11/17/22 4:08 PM now I want to check if it is more than 24 hrs means 11/18/22 4:08 PM and still, the status is In Progress then it shows me some red flag but I am unable to find any formula for it and as per my knowledge there is no way to check with the exact time.
Any help would be appreciated.
Senior Associate - Smartsheet Development, Ignatiuz Software
2023 Core Product Certified
Did this answer help you? Show some love by marking this answer as "Insightful💡" or "Awesome❤️" and "Vote Up⬆️"
Help Article Resources
Check out the Formula Handbook template!