Ask LibreOffice - RSS feedhttps://ask.libreoffice.org/en/questions/Questions and answers for LibreOfficeenMon, 09 Jul 2018 17:58:16 +0200Multiplying timehttps://ask.libreoffice.org/en/question/160175/multiplying-time/ I need to keep hours for a group of volunteers and report the total monthly. Sometimes they work in groups and sometimes they work individually. I created a spreadsheet with columns for start time, end time, elapsed time, and number of volunteers present. I formatted the first two time columns HH:MM AM/PM and the elapsed time column HH:MM. To get the elapsed time, I subtract start time from end time and that does display the correct elapsed time.
Then it goes haywire. At first I tried to sum() the elapsed time column and then multiply it by the sum() of the number of volunteers present column. Somehow 13:00 x 12 computes to 16:00. I tried just manually multiplying the total sum() of the elapsed time column by 12 and got the same result.
Can anyone tell me what I'm doing wrong, or how to achieve my objective? I don't want to have to make an entire row entry for each volunteer because the report would become very large, very fast and also because there are a lot more columns of other types of data that I don't want to have to replicate for each volunteer.
Thanks,
--BrianBrianMMon, 09 Jul 2018 17:58:16 +0200https://ask.libreoffice.org/en/question/160175/multiply two cells and recalculate if a value is changed?https://ask.libreoffice.org/en/question/21336/multiply-two-cells-and-recalculate-if-a-value-is-changed/Ok, absolute newbie to spreadsheets here. I have entered the function (eg: =c1*d1 to display result in e1)which works but if I change a value in one of those C1 or D1 cells, it doesn't update the result cell. Any help much appreciated.capetowngrahamSun, 11 Aug 2013 18:28:58 +0200https://ask.libreoffice.org/en/question/21336/