How to convert HH:MM to a numeric value

Denzell Argel Ornedo

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!

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

Stefan