Sum of Duration fields with result in hrs

Monica Ladd

Monica Ladd ✭✭✭

08/06/24 in Formulas and Functions

Hello,

I am trying to create a formula to summarize a number of fields in a duration column. The default value of the SUM is days, is there a way to have the output in hours rather than days?

0 ·

Answers

Paul Newcome Community Champion

08/07/24

You would multiply the result by 24.
=SUM(Duration:Duration) * 24

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

I want to send automated email to "assigned to", from a sheet, but only one reminder email vs mutlip
I have title, "assigned to" column, status(task 1), due date (task 1) columns, status(task 2), due date(task 2)…it goes for at least 10 tasks. The conditions to trigger the emails are, trigger 2 days before due date(when status is not equal to completed) and leave weekends trigger on due date(when status is not equal to…
Conditional formatting for "where % complete is not equal to 1" is not working
I have a project plan where I'm trying to set conditional formatting where % Complete is not equal to 1 and Finish Date is in the past, to turn row Yellow. It is not working. Please advise.
Mass Remove Hyperlinks
Is there a quick way to mass remove hyperlinks within specific columns on a Smartsheet? I do not want to "clear content", just remove the hyperlinks.