Forum Discussion
Leading zeros
Hello all! I have a sheet on which I paste from a website. The values are times with three spaces for hours (hhh:mm:ss), the problem is that I need to sum up the values in a column, and for some ...
You can use a formula such as
=SUM(IF(A1:A10<>"",TIMEVALUE(MID(A1:A10,2,8))))
If you do not have Microsoft 365 or Office 2021, confirm the formula by pressing Ctrl+Shift+Enter.
Apply the custom number format [h]:mm:ss or [hh]:mm:ss to the cell(s) with the formula.