Sum Formula to Calculate Duration in Hours Not Days

Caitlin W.

Hello!

Is it possible to set up a sum formula that shows the duration of time spent on something in hours and not days? We are using a task tracker and many of our items are in minutes and hours and the metrics tell a better story when it is based on hours per individual on my team.

Any advice in this space would be amazing. At the moment we have settled for the sum of duration in days.

Jeff Reisman

@Caitlin W.

There is not currently functionality to record and count hours/minutes in Smartsheet, unless you enter times manually and use the existing math functions.

Feel free to enter a product enhancement request here:

https://app.smartsheet.com/b/form?EQBCT=739aa75f30ca43a8a22eb53e4da7d409&_ga=2.196835178.757541251.1598879265-1557598792.1594053397

Jeff Reisman

@Caitlin W.

There is not currently functionality to record and count hours/minutes in Smartsheet, unless you enter times manually and use the existing math functions.

Feel free to enter a product enhancement request here:

https://app.smartsheet.com/b/form?EQBCT=739aa75f30ca43a8a22eb53e4da7d409&_ga=2.196835178.757541251.1598879265-1557598792.1594053397

Andrée Starå

Hi @Caitlin W.

I hope you're well and safe!

This might help!

Please have a look at my post below with a method I developed.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

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

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