[opensuse] Tricky spreadsheet problem, could really use some help.

I used to know spreadsheets, but I completely forgot how to use them and
have been trying to retrain myself. I normally use Lotus Symphony which
is based off of OpenOffice 3. I expect the behavior should be the same
between Lotus and LibreOffice.

I want to build a time-sheet. Sheet one has the time being tracked, and
the summary sheet should sum up the values giving total money owed, and
hours used on each project.

Currently I have it set up on the first page with columns for the
following; Date, Project, Task, Start, Stop, Subtotal, and Notes. I use
the formula under 'Subtotal' to calculate the time between 'Start' and
'Stop'. That works correctly, though I do not know how to get it to
apply to all of the column automatically so I don't have to manually
reenter the formula each time.

I anticipate the summary page will be more difficult. I want it to be
able to not only give a total of hours, and the pay owed, but to be able
to display what the total hours were spent on each project. I'd like it
to automatically populate this list based on my entries under
'Projects.' I haven't the foggiest of conceptions on where to start on
this page of the workbook.

Any help would be immensely appreciated.

--
To unsubscribe, e-mail: opensuse+unsubscribe@xxxxxxxxxxxx
To contact the owner, e-mail: opensuse+owner@xxxxxxxxxxxx

Relevant Pages