2012/8/8 teknow <teknowledgist@gmail.com>:
Thanks for the responses.
I'm being given an already filled-out .xlsx, but I'm not seeing a difference
if I save it to .ods.
The cells are identified as in H:MM format, but the actual measurements are
in minutes and seconds (with a few H:MM:SS sprinkled in). It's a bit
confusing because what I see in the Cell is "1:18" as in one minute and
eighteen seconds, but what I see in the input line is "01:18:00 AM". The
hours and minutes makes sense, but what is that "AM" doing there? If I
switch to text format, I get decimal numbers (e.g. 0.0541666666666667 in the
"1:18" cell).
0.0541666666666667=1:18:00 (1 hour, 18 minutes)
1.0=24:00:00
0.5=12:00:00
0.25=06:00:00
and so on.
To be exact, 0.5 really means 1899-12-30 12:00:00 (0.5 days since
1899-12-30 00:00:00), the same for 1.0 which then means 1899-12-31
00:00:00.
Formatting to a pure time format, such as HH:MM:SS ”hides” the date,
so we don't need to bother about irrelevant years, months and days,
for example when you sum times.
The format you see in your input line is probably dependent on your
language settings, therefore the AM in your case and not in my case.
Kind regards
Johnny Rosenberg
ジョニー・ローゼンバーグ
Completely not understanding, I was doing some text manipulation (copy to
notepad, add "00:" to the front end, copy back) to try to get the values
recognized as minutes and seconds, and that appears to have caused the
screw-up. I suppose pursuing why those cells add like time (seconds roll
over to minutes at 60, etc.) when they only look like time values, but don't
sum() at all should be left for another day.
If I ignore the entries with hours (which I suspect are erroneous anyway)
and simply divide the original cells by 60, and set the formatting to
[H]:MM:SS, I appear to be getting what I need and sum() works as I would
expect.
Sorry for the confusion.
--
View this message in context:
http://nabble.documentfoundation.org/Can-t-Sum-time-measurements-tp3999947p4000013.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
Context
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.