CODEWITHSUNDEEP
libreoffice-calc
user3724234
user3724234

Reputation: 45

How to sum under different sheet with conditions? Libreoffice calc

I have a libre office calc spreedsheet containing over 10 sheets.

They have the same structures.

on the standard sheet there are multiple columns with start and end which people need to put their timestamp(C2 = 2015-04-21 02:28 and D2 = 2015-04-21 03:31)

I can calculate the time easily with this doing D2-C2

I need to create another sheet to sum all time that had been done within a day.

What I think of doing is : -Add every cell within the range of sum(firstsheet.C2:lastsheet.C100) that has the same day (ex. 2015-04-21) -Do the same with the D row -Substract the 2 rows so I can only get the total time in hours for one day

Is there any way to do this without using macro?

Upvotes: 0

Views: 1598

Answers (2)

Lyrl
Lyrl

Reputation: 935

I believe you'll be better off putting all the data into one sheet and using a pivot table (or multiple pivot tables) to display the daily sums as well as whatever "report" type information you're currently displaying on each sheet.

Sometimes a pivot table is called a data pilot - they are the same thing. For your application, they work the same in Excel as in LibreOffice, so if you're looking for information Excel tutorials are valid. Here is also a tutorial on the OpenOffice wiki: Using the DataPilot - Please note the links to each part of the tutorial is through the table of contents on the right side of the page.

Upvotes: 1

EmbedWise
EmbedWise

Reputation: 174

Here is a link with some explanation Libre Office help

I did not try it but maybe the sheets should have a name y with X incrementing by 1. So the format yX

Upvotes: 0

Related Questions