>>>>BTW I have one question what happens if some employee work on one location Monday and other in Thursday?
>>>
>>>This does happen. All they do is enter the times in the relevant days for each location.
>>
>>The others already set you straight on denormalizing the non-data-entry table ;-)
>>Not knowing the travel time between locations: Person A starts at location A at 8, gets called to rush to Location B at 9, works there till 13:30 and arrives back at A to work the rest of the day. Will earn some double time if there is only 1 begin and 1 end each day at each location ;-))
>
>I guess that could happen :)

Introduce me for a location-spanning job at that outfit ;-)