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!
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.
Looking to connect a dynamic view of HR dataset to a Power BI dashboard pulling information from multiple other sources. Appreciate any guidance, thanks
Hello! I copied a form I had made for a similar event I am working on now. I made minor adjustments to the form to match the needs of the event. I distributed the form for people to complete, so the form is active, but the data is not populating onto my Smartsheet. Please advise. I would prefer not to have people redo the…
Hello, when I modify a start date on a task I lose the predecessor links. Is there a method to modify task start dates without losing the links? THANKS.
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.