Description: I have three cells with time hours; for example: 16:00:00 16:00:00 08:30:00 When I select all these cells, its value is automatically displayed at the bottom bar. This displays 16:30:00 when it should display 40:30:00 Regards. Steps to Reproduce: 1. Put these values inside three cells 2. Select all these three cells. 3. At the bottom bar, right, it displays wrong value. Actual Results: It displayed a wrong value. Expected Results: Displays 40:30:00 Reproducible: Always User Profile Reset: No Additional Info:
The issue here it's sum show the sum in the same format as the cells HH:MM:SS so the result it's fine, 40:30:00 = 1 day plus 16:30:00 but to show as sum of hours the format should be [HH]:MM:SS, what you can get if at least the first in the selected range have this format ([HH]:MM:SS). So I don't think it is a bug.