>>>>>>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 ;-)
>
>You any good at serving fast food?

Nope - not even eating it ;-)