2012/8/8 teknow <[email protected]>: > I have a list of measured times in [H]:MM:SS format and I would like to sum > them. If I put in a formula: > > = B2+B3+B4+B5 > > it works, but if I try: > > =Sum(B2:B5) > > I get "00:00:00" as a result. What am I missing?
Exactly how did you enter those time values in the first place? What happens if you, in C2, enter ”=B2” and then format C2 as a number with a lot of decimals? Time works just like date in a spreadsheet. Date is a number of days since 1899-12-30 (unless you set it to something else in Options) while time is a number ≥0, <1. The value is then formatted to a ”human readable time format”, but the cell still contains a number. Kind regards Johnny Rosenberg ジョニー・ローゼンバーグ > > I have tried both LibO 3.5.5.3 and 3.6.0.4 > > Thanks. > > > > > > -- > View this message in context: > http://nabble.documentfoundation.org/Can-t-Sum-time-measurements-tp3999947.html > Sent from the Users mailing list archive at Nabble.com. > > -- > For unsubscribe instructions e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be deleted > -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
