How to convert HH:MM to a numeric value


I wanted to know how can I convert this hh:mm into a numeric number so I can easily add them?

Hope you can help me with this. Thank you!


  • Stefan
    Stefan ✭✭✭✭✭✭

    Hi @Denzell Argel Ornedo,

    I suggest using one column for hours and another for the minutes. That way you can use standard calculation in a cell to sum hours and minutes separately and combine them into one result.

    Hope this helps


    Smartsheet Consulting, Solution Building, Training and Support.

    Projects for Processes and for People.