Sum total minutes on Excel 365 (web version of Excel)

[snjpverma]

Every task has a defined minutes as shown below.

Defined Minutes for Level 1:

Task 1	14
Task 2	10
Task 3	12
Task 4	20
Task 5	26

Defined Minutes for Level 2:

Task 1	8
Task 2	22
Task 3	14
Task 4	17
Task 5	15

Whatever task we perform we enter it in Excel like this:

Date	Task	Level
Aug 7, 2024	Task 4	One
Aug 7, 2024	Task 6	Two
Aug 7, 2024	Task 2	One

We usually need to complete 480 minutes in a day by completing the task that are assigned to us.

I would like to get the total of the minutes of the work that I have completed. How can I do that.

Summary Table:

Date	minutes Worked
Aug 5, 2024	Output required
Aug 6, 2024	Output required
Aug 7, 2024	Output required

Please assist.

 

[etaf]

a lookup to find the minutes and then add them together
can you put a lookup table together

Level / task / Mins

task 6 , not on list , howmany tasks are there

i have made the dates REAL Dates
Added the time in your list
and then summarised

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
1										level	Task	Min
2	Date	Task	Level	Time						One	Task 1	14
3	7-Aug-24	Task 4	One	20						One	Task 2	10
4	7-Aug-24	Task 2	Two	22						One	Task 3	12
5	7-Aug-24	Task 2	One	10						One	Task 4	20
6										One	Task 5	26
7										Two	Task 1	8
8										Two	Task 2	22
9										Two	Task 3	14
10										Two	Task 4	17
11										Two	Task 5	15
12
13
14
15
16
17	Date	minutes Worked
18	5-Aug-24	0
19	6-Aug-24	0
20	7-Aug-24	52
Sheet1

Cell Formulas
Range	Formula
D3:D5	D3	=INDEX($L$2:$L$11,MATCH(C3&B3,$J$2:$J$11&$K$2:$K$11,0))
B18:B20	B18	=SUMIFS($D$3:$D$5,$A$3:$A$5,A18)

 

[felixstraube]

Would something like this work?:

Book9.xlsx
	A	B	C	D	E	F	G	H	I	J
1		Level 1	Level 2							45
2	Task 1	14	8				Date	Task	Level	Minutes worked
3	Task 2	10	22				07/08/2024	Task 4	One	20
4	Task 3	12	14				07/08/2024	Task 5	Two	15
5	Task 4	20	17				07/08/2024	Task 2	One	10
6	Task 5	26	15
Sheet8

Cell Formulas
Range	Formula
J1	J1	=SUM(J3:J17)
J3:J5	J3	=INDEX($B$2:$C$6, MATCH(H3, $A$2:$A$6,0), MATCH(I3, {"One","Two"},0))