I am trying to create a time sheet using Nintex 2010 and SharePoint 2010. Currently I have two lists.
List A(Hours) - records employees time in and time out. There are seven columns Employee Name (person or group), Date (date&time), Time in(single line of text), lunch break(single line of text), time out(single line of text), total hours (calculated) and comments.
List B(TimeSheet) - I want to record the hours based on list A and total it. I have columns Sunday to Saturday twice, Employee Name, Pay Day, Total Hours, Pay Period Start and Pay Period End .
How can I create a workflow to copy the data from to the other?
I was thinking of using a formula:
=and(Weekday([Pay Period Start])=2))
To get the first Monday that falls in that pay period
Here's what I have so far:
Can anyone help?