How to convert HH:MM to a numeric value
Hi,
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!
Answers
-
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
Stefan
Smartsheet Consulting, Solution Building, Training and Support.
Projects for Processes and for People.