Time

[arnapsui]

Hi

I have a list of employees and the total time they worked in excel. I need to calculate the Overtime for each. Please note the example below:

EmpName WorkedTime DutyHoursPerDay WorkedDays OT

A 174:00:00 8 27
B 322:50:00 8 27
C 284:30:00 9 27
D 124:45:00 9 27

How can I calculate the OT for each employee?

Note that I have formatted the WorkedTime column as [h]:mm:ss. This is why I get the WorkedTime from our HandPunch Machine.

Anyone can help me?

 

[Tuelor]

Set up a formula saying,

=WorkedTime - (DutyHoursPerDay * WorkedDays)

 

[meldoc]

Hello

Try.

Excel Workbook
	A	B	C	D	E
1	EmpName	WorkedTime	HoursPerDay	WorkedDays	OT
2	A	174:00:00	8	27	0
3	B	322:50:00	8	27	106.8333
4	C	284:30:00	9	27	41.5
5	D	124:45:00	9	27	0
Sheet1

Excel 2010

Cell Formulas
Range	Formula
E2	=IF(B2*24-(C2*D2)<=0,0,B2*24-(C2*D2))

 

[T. Valko]

Hi

I have a list of employees and the total time they worked in excel. I need to calculate the Overtime for each. Please note the example below:

EmpName WorkedTime DutyHoursPerDay WorkedDays OT

A 174:00:00 8 27
B 322:50:00 8 27
C 284:30:00 9 27
D 124:45:00 9 27

How can I calculate the OT for each employee?

Note that I have formatted the WorkedTime column as [h]:mm:ss. This is why I get the WorkedTime from our HandPunch Machine.

Anyone can help me?

Here's another one...

Book1
	A	B	C	D	E
1	Name	Total Time	Hrs/Day	Days	OT
2	A	174:00:00	8	27	0:00
3	B	322:50:00	8	27	106:50
4	C	284:30:00	9	27	41:30
5	D	124:45:00	9	27	0:00
Sheet1

Formula entered in E2 and copied down to E5:

=MAX(0,B2-(C2*D2/24))

Format as [h]:mm

 

[arnapsui]

Thank you very much. I will try your solution.

 

[T. Valko]

Thank you very much. I will try your solution.

You're welcome!