How to calculate time

Kaveri Vipat

Hello Everyone,

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.

Paul Newcome

We are up to 13 pages in this thread, but there should be something to help you get started in here. Take a look to calculate the difference between start and end times. You can then incorporate a flag with an IF statement that says if the time difference is greater than 24, flag the row.

https://community.smartsheet.com/discussion/68947/formulas-for-calculating-time