I know how to calculated date/time in Excel. The issue is the variability in filling in the fields as allowed by the data structure. If Jan has a start time of 7:00 AM and doesn't check out until 4:00 PM, that will complete the first in/out pair and nothing in the rest of the columns. Why skip all the way down to Finsh to fill in the only Out? A more normalized table structure would be:
Code:
RecID | EmpID | In | Out
1 | J | 01/15/2011 07:00 AM | 01/15/2011 11:00 AM
2 | J | 01/15/2011 12:00 PM | 01/15/2011 04:00 PM
Data from an old fashioned punch clock would probably be more like:
Code:
RecID | EmpID | TimePunch | InOut
1 | J | 01/15/2011 07:00 AM | In
2 | J | 01/15/2011 11:00 AM | Out
3 | J | 01/15/2011 12:00 PM | In
4 | J | 01/15/2011 04:00 PM | Out
Having to test if data is provided seems even more complicated in Excel. There is an ISBLANK function that could be use with an IF expression.