Sum duration with the result in hours

Options

I try to sum children durations wich are in hours.

It works with the formula "=SUM(CHILDREN())" but the result is always in days.

I don't find how to change it.

Thank's in advance.

Ex :

Best Answer

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    edited 06/03/24 Answer ✓
    Options

    =Sum(Children())*24+"h"

    Now keep in mind this will actually be a text value.

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

Answers

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    Options

    @T_knoWeb

    How exactly are you pulling the H. This will help in the formula I would build for you.

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

  • T_knoWeb
    Options

    I just enter for example 7h in the cell (I need the column in hours and if I don't enter it it will default to days).

  • Mark.poole
    Mark.poole ✭✭✭✭✭✭
    edited 06/03/24 Answer ✓
    Options

    =Sum(Children())*24+"h"

    Now keep in mind this will actually be a text value.

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!