https://bugs.documentfoundation.org/show_bug.cgi?id=161043
--- Comment #4 from Colin <that.man.co...@gmail.com> --- (In reply to ady from comment #3) > (In reply to m_a_riosv from comment #2) > > What if you use to format the cell > > [HH]:MM:SS,00 > > Or [HH]:MM:SS.00 if your decimal separator is the period dot rather than the > comma. Both this and SS,00 make matters worse; The cell fills with pointless empty values and the subtotal() still thinks three weeks is a little over 12 hours. Neither of the formats accumulates 65 minutes as 65:00 which is what I would expect. Excel, given the same structure (but I didn't experiment with a single cell accumulating 65:00), produces the correct SUBTOTAL() If I force the format 876613:37:46 into cell D1 it correctly accumulates all the "integer" hours - I have no idea where that format originated, I just discovered it playing with the above suggestions. -- You are receiving this mail because: You are the assignee for the bug.
