https://bugs.documentfoundation.org/show_bug.cgi?id=147825
--- Comment #8 from L.H. Carsten <[email protected]> --- (In reply to m.a.riosv from comment #7) > (In reply to L.H. Carsten from comment #0) > > ... > > 2.Enter =TIME(0,0,A1) in 3 other cells (e.g. B1,B2,B3) > > ... > > I'm wrong or TIME() gives a time result as part of one day > 23:59:59 =TIME(0;0;86399) > 23:59:00 =TIME(0;86399;0) > 23:00:00 =TIME(86399;0;0) > it returns the maximum for seconds, minutes or hours, and the format [xx] > has only one value to sum. > > I think there is not a bug. Indeed it seems the 'issue' is with the Time function not with the cell format. Change the cell format to number general and the output of the =Time() is always < 1 Not sure if it's a bug or a feature though! -- You are receiving this mail because: You are the assignee for the bug.
