Ask Your Question

BrianM's profile - activity

2021-05-01 12:30:08 +0200 marked best answer 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,

--Brian

2020-12-08 20:27:53 +0200 received badge  Good Question (source)
2020-09-11 22:20:10 +0200 received badge  Famous Question (source)
2020-08-22 13:09:08 +0200 received badge  Notable Question (source)
2020-08-22 01:16:38 +0200 received badge  Popular Question (source)
2020-08-21 23:14:57 +0200 received badge  Commentator
2020-08-21 23:14:57 +0200 commented answer Simple page numbering

Weird, but it works. Thank you.

2020-08-21 23:14:32 +0200 marked best answer Simple page numbering

It used to be that when you printed a document you could click a little box to enable page numbering. Voila!

I'm honestly not sure how long ago that was - maybe dinosaurs roamed the earth - but that does not appear to happen anymore.

Sometimes I might want to meticulously format my entire document to the pixel, but sometimes I just want to blast out a quick outline or letter or something and I just want page numbers. I don't want to have to care about formatting the page numbers; I don't care where they are, just so long as every page has one.

And I don't want to have to figure out some complex mantra to make it happen.

Is this possible? If so, how do I do it?

Thanks!

2020-08-21 21:18:26 +0200 asked a question Simple page numbering

Simple page numbering It used to be that when you printed a document you could click a little box to enable page numberi

2019-05-24 11:20:54 +0200 received badge  Famous Question (source)
2018-07-11 00:22:59 +0200 received badge  Notable Question (source)
2018-07-10 23:25:17 +0200 commented answer Multiplying time

Yup, that was the answer. Thank you very much, JohnSUN!

2018-07-10 23:24:50 +0200 commented answer Multiplying time

Yup, that was the answer. Thank you very much!

2018-07-09 22:46:25 +0200 received badge  Popular Question (source)
2018-07-09 17:58:16 +0200 asked a question Multiplying time

Multiplying time I need to keep hours for a group of volunteers and report the total monthly. Sometimes they work in gr

2015-08-15 00:00:20 +0200 received badge  Famous Question (source)
2015-08-14 23:14:34 +0200 received badge  Scholar (source)
2015-08-14 06:31:50 +0200 commented answer Page break preview not working in Calc

OK, I added a test file. It has two sheets in it. The first one is an example of the problem, the second shows the breaks correctly. On my system. Hopefully on yours, too! :)

2015-08-13 10:07:36 +0200 received badge  Nice Question (source)
2015-08-13 08:04:02 +0200 received badge  Student (source)
2015-08-13 03:40:40 +0200 commented answer Page break preview not working in Calc

I think I figured it out, I went back to my original message and found a paper clip and tried to attach the file, but it says I need >3 points to do it. How do I get points?

2015-08-13 03:17:37 +0200 commented answer Page break preview not working in Calc

Is there a way to do this within this forum? Otherwise I suppose I could put a file up for you to download.

2015-08-13 03:14:12 +0200 received badge  Enthusiast
2015-08-12 19:57:40 +0200 received badge  Notable Question (source)
2015-08-11 19:21:22 +0200 commented answer Page break preview not working in Calc

Regarding your edit. I just looked at it. I don't have a "-Scale" option so I'm guessing you mean to adjust the scaling. Currently the option is set as Reduce/Enlarge Printout. It is this way both on the sheet that displays correctly, and on the one that displays incorrectly. They are also both set to a scaling factor of 100%. So I don't think that's it.

2015-08-11 16:35:11 +0200 received badge  Popular Question (source)
2015-08-10 23:51:43 +0200 commented answer Page break preview not working in Calc

Thanks. I tried it, but that's not it. I have no manual breaks, nor do I want any. What I want to do is select View|Page Break Preview and see the breaks which have been applied automatically. Then I will shrink my cells down until they just fit on one page.
Unfortunately, when I turn on the Page Break Preview, it just shows the whole spreadsheet on a medium to dark gray background with no breaks. And yet it prints with breaks so I know they are there. I've even tried enlarging my sheet

2015-08-10 16:11:28 +0200 asked a question Page break preview not working in Calc

I've used this successfully before, but not now. I have a spreadsheet which doesn't fit on a single sheet of paper. I need to see the breaks so I can adjust accordingly. When I select the Page Break Preview in the View menu I see a slightly shrunken version of my page on a large, medium gray back ground and with no sign of where the breaks might be. It's just one spreadsheet. I've got another one open right next to it and breaks are displayed correctly. What am I doing wrong? Thanks.

Edit: adding a sample file, as requested.TestFile.ods

2015-08-09 02:53:27 +0200 received badge  Famous Question (source)
2014-07-14 20:22:32 +0200 commented answer How to setup for automatic decimal.

Hmmm, I'll experiment with it, but it sounds too fussy. And if I miss a cell, then I have a serious mistake that can cost me money in an audit. Pretty much the same problem as if I forget to type in a decimal point with the current situation.

Manipulating formatting only happens a few times even on a huge spreadsheet because I just copy/paste rows and the formatting and formulae follow automatically and everything is always formatted correctly.

I wonder if a format can be stored as a sequence of events or formulae. That would really modernize the spreadsheet - these things haven't changed all that much since the SuperCalc that came with my Osborne I computer back when dinosaurs roamed the earth. One problem they all seem to have is that a cell can't seem to change its own contents. What I really want is ... (more)

2014-07-14 11:27:18 +0200 received badge  Notable Question (source)
2014-07-13 20:22:30 +0200 commented question How to setup for automatic decimal.

There would be no point to that. If I have to push an extra key I'll push the dot. The real point is that when you enter a LOT of monetary amounts on an accounting calculator or into accounting software, you get into a rhythm which allows you very fast and accurate data entry. Having to constantly remember to put in the decimal - when the computer should be able to do that for you - and having to backspace every few entries when you forget the decimal, or having your data full of errors because you didn't notice that you forgot the decimal really messes things up. Without the automatic decimal, this just isn't professional level accounting or bookkeeping software. I suppose it's great as a general purpose spreadsheet, making presentations or for people who don't routinely do a lot of bookkeeping, but that's about it.

2014-07-13 18:37:32 +0200 commented answer How to setup for automatic decimal.

I tried submitting a problem report once. I don't remember exactly what it was anymore, but I sure learned to stay away from that bugtracker. I wasted a lot of time. As I remember it, I stated the problem and then was asked to re-state it. I re-stated it and someone reproduced it. A couple of years later I got a notice that it had been cancelled because I had not provided additional information. Hah! Fool me once, shame on you, fool me twice, shame on me.

I think LibreOffice and OpenOffice are very good software designed by hobbyists who don't always understand the "markets" that would like to use their software. The developers work on what they want to work on and prioritize their work based on their interests, not on the needs of their customers. I think this is very reasonable and I don't blame ... (more)

2014-07-13 18:36:33 +0200 answered a question How to setup for automatic decimal.

I tried submitting a problem report once. I don't remember exactly what it was anymore, but I sure learned to stay away from that bugtracker. I wasted a lot of time. As I remember it, I stated the problem and then was asked to re-state it. I re-stated it and someone reproduced it. A couple of years later I got a notice that it had been cancelled because I had not provided additional information. Hah! Fool me once, shame on you, fool me twice, shame on me.

I think LibreOffice and OpenOffice are very good software designed by hobbyists who don't always understand the "markets" that would like to use their software. The developers work on what they want to work on and prioritize their work based on their interests, not on the needs of their customers. I think this is very reasonable and I don't blame them a bit. I do not like people telling me how to pursue my hobbies, either. But software development isn't my hobby. I can't fix this problem myself and I doubt that any of the developers have ever used this function on their calculator even if they have it. So the same thing will probably happen as happened the last time. Time will be wasted, time will pass, and the request will go nowhere.

Anyway, my desktop accounting calculator has this very basic functionality. Any software that cannot do it isn't suitable for keeping extensive financial records on. Little onsy-twosy spreadsheets, fine, but not large ones with itemized expenses for larger projects spread over different asset and expense categories. So I'll look around at the other spreadsheet out there and see if any of them can do it.

2014-07-13 09:57:05 +0200 received badge  Popular Question (source)
2014-07-13 00:40:30 +0200 received badge  Editor (source)
2014-07-13 00:39:49 +0200 asked a question How to setup for automatic decimal.

My accounting software and my accounting calculator both do a really handy thing: they insert the decimal for me. If, for example, I type in 123456, it will be automatically converted to $1234.56. If I type 1200 it will become 12.00 unless I override by typing in the decimal where I want it. So if I want 1200.00 I can either type 1200. or 120000. Both my calculator and my numeric keypad have a 00 key to make data entry faster when you have lots of zeros.

SO, is there any way to do this in calc? Is it a setting somewhere, or a number format that I can't find or what?

Thanks.