2012/8/8 teknow <teknowledgist@gmail.com>:
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: users+help@global.libreoffice.org 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: users+help@global.libreoffice.org 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