SharePoint InfoPath TImeSheet

Avg Bid (USD)
Project Budget (USD)
$30 - $250

Project Description:
I have create a form in infopath and I need someone to complete the calcucation.


TimeIn -TimeOut = TImeWorked (9:00 AM - 5:00 PM = 8 hours worked)

I have a field called "PayPeriodStartDate" that user choose from a drop down menu, I need to make sure that in the repeating table that has a field call "PayPeriodDate" that the user is can only choose dates that are in two weeks of the PayPeriodStartDate or they get a validation error.

I have a drop down menu that contains sites, I need for each site to calculate hours worked at a certain site. I have attached the InfoPath form to give you a look at the scope of the work.

Any codeing needs documentation

Additional Project Description:
10/13/2011 at 9:29 NZDT
I have total of 5 list (Staff List, Pay Periods, Time Intervals and Pay Periods)

Pay Periods has a calculated column named StartDate that is populating a drop down list in the infopath named PayPeriodStartDate

The issue that I'm having is that I have I had to use this forumla (=TEXT([Start Date], "mm/dd/yyyy") for the StartDate calcuated column
because I need the date to be in the "mm/dd/yyyy" format.

This means that the data is passed as a string and I run into a problem when I try to enforce a rule on a date field named PayPeriodDate that will make sure the user in within 2 weeks of the PayPeriodStartDate

the user picks 10/1/2011 for a PayPeriodStartDate that means that the date has to be between 10/1/2011 and 10/14/2011 or they will get a vaildation error

The next issue is that I have two drop down time fields called TimeIn and TimeOut and another text box field named hours that will show the results of the time a user worked.


TimeIn = 9:00 AM TimeOut = 5:00 PM then hours = 8

I can't figure how in infopath to calculate the hours field and I had to manually enter the time in TimeIn and TimeOut and I would rather they get that information from a sharepoint list.

Lastly I have several field at the end that give a subtotal for hours worked at each site and overtime for week 1 and week 2. they have to calculate correctly based on the user input.

I have attached the the infopath form and excel spreadsheets that contain the sharepoint list info

Skills required:
.NET, C# Programming, Sharepoint, Website Design
Additional Files:
About the employer:
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$ 500
in 3 days
$ 450
in 3 days
Hire jatinkindra
$ 320
in 4 days
$ 200
in 7 days
Hire KAbhishekS
$ 220
in 5 days
Hire gavincg
$ 300
in 7 days
Hire steve5555
$ 222
in 4 days
Hire jeffnathan
$ 220
in 4 days
Hire sheralistar
$ 220
in 10 days
Hire jakit1989
$ 140
in 2 days