Amount calculation in progress

[McM_]

Hi everyone
I come with a problem that I can't solve. I have to add up the hours worked by the employees every day.
Everyone's working days and the number of hours worked is variable, not being a work regime with a fixed schedule. As a result, I have to total the hours worked for that day, but also how many hours they worked up to that moment.
In column B I have hours worked that day and in column C total hours worked from the beginning to that moment, but I don't know which formula to apply
For example in the attached table:
Employee 1
on day 1 he worked 7 hours (total 7)......on day 2 he worked 6 hours but he also has a total of 13 (7+6) hours until day 2, on day 3 he worked 9 hours, so the total will be 21 (7+6+9) hours
Employee 2
on day 1 he worked 4 hours (total 4), on day 3 he worked 8 hours, with a total of 12 hours (4+8)...
.....
and so on for each employee for a month. We have a number of 135 employees, so I definitely need to optimize the table for these calculations.
Thank you for your help!

		IN THIS COLUMN I NEED THE FORMULA
	hours worked	total hours/employee	day
Employee 1	7	7	day 1
Employee 2	4	4	day 1
Employee 1	6	13 (7+6)	day 2
Employee3	10	10	day 2
Employee3	8	18 (10+8)	day 3
Employee 2	8	12 (4+8)	day 3
Employee 1	9	21(7+6+9)	day 3

 

[dreid1011]

Give this a try:

Book1
	A	B	C	D
1			IN THIS COLUMN I NEED THE FORMULA
2		hours worked	total hours/employee	day
3	Employee 1	7	7	day 1
4	Employee 2	4	4	day 1
5	Employee 1	6	13	day 2
6	Employee3	10	10	day 2
7	Employee3	8	18	day 3
8	Employee 2	8	12	day 3
9	Employee 1	9	22	day 3
Sheet1

Cell Formulas
Range	Formula
C3:C9	C3	=SUMIF($A$3:A3,A3,$B$3:B3)

 

[felixstraube]

So basically you need to keep a register of how many hour your employees have worked each day, and than get the total for each employee?

Would it make sense to do this?

Book1
	A	B	C	D	E	F	G
1	Employee	Total	Day 1	Day 2	Day 3	Day 4	Day 5
2	Employee 1	38	8	8	7	7	8
3	Employee 2	35	6	9	6	7	7
4	Employee 3	33	8	6	6	7	6
Sheet1

Cell Formulas
Range	Formula
B2:B4	B2	=SUM(Sheet1!$C2:$G2)

 

[McM_]

Thank you for help!!!
In particular
dreid 1011,
it's what i needed.

felixstraube
your formula works but it doesn't help what I need
Thank you guys!

 

[dreid1011]

You're welcome, and happy to help.