When adding the time values in range, such as total working overtime hours for employees, and it is needed to format as [h]:mm:ss. Otherwise, although the total hours is more than 24, it will stuck to 24 and could not be able to show the actual values. If is not the summation errors. It is just a Read more Time format that effects the value