About Time Calculation

ABHI

How can we calculate time between start date and finish date? I want to know by hour and minute format?

Ezra

I built this a while back.... read comments for the formulas

https://app.smartsheet.com/b/publish?EQBCT=698fa97db2e848acbba1db03ca04667b

ABHI

Thank you for sharing this but is there any automated format or formula to calculate time without manually entering by users?

Ezra

Nothing built in at the moment.. I believe some use Zapier to grab a Modified Date and hard-code it into a cell every time something specific happens.

Andrée Starå

Ezra is correct!

Zapier is a great option for this scenario. Is that an option for you?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

ABHI

I tried using Zapier but how? Zapier wants me to buy timecap app as well. 

Azuqua seems pretty promising but my company doesn't want it since they think it might compromise the security.

 

Andrée Starå

What do you mean with that Zapier wants you to buy timecap?

Azuqua was excellent, but they have been acquired, and it's being retired for external use.