Workinghours - How to do this ?

[separerl]

Hi !

I have the following raw data:

EmployeeNumber	EmployeeName	TypeCode	TimeStart	TimeEnd
158	Donald Duck	Break1	09:00	09:15
158	Donald Duck	Break2
158	Donald Duck	Lunch	12:00	13:00
158	Donald Duck	WorkingHours	07:00	16:00

and I want this result

EmployeeNumber	EmployeeName	TotalWorkTime
158	Donald Duck	07:45

TotalWorkTime is Workinghours minus Lunch minus Break1&2

Any ideas ?

I attach a sample.

/Pär

[#2 · Accepted solution]

Here is something that can help ( I hope )

Philippe

[separerl]

Hi Philippe !

This works like a dream !

Thanks a lot for your help !!

/Pär