Add Duration to date/time

Ann Bolland

For a software release plan, I need to show the duration of a task but unable to translate my Excel formula to Smartsheet. Any thoughts?

These are the fields I am using -

Andrée Starå

Hi @Ann Bolland

I hope you're well and safe!

Here's a resource from Paul Newcome with many different time-based solutions.

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

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Bassam Khalil

Andrée Starå

Hi @Ann Bolland

I hope you're well and safe!

Here's a resource from Paul Newcome with many different time-based solutions.

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

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Ann Bolland

Thank you both!