Getting StartTime and Endtime from TimeStamp Field but DateWise
Hello I have a table with fields :
123 26/08/2013 9:04:08 AM
124 26/08/2013 9:05:15 AM
124 26/08/2013 9:05:20 AM
123 26/08/2013 17:00:15 PM
124 26/08/2013 18:01:45 PM
I have created 2 fields CheckIn and CheckOut in the same table. What calculation can I use to get the timing from the timestamp field which will then feed into the CheckIn and CheckOut fields as per the timing of the employee to come and leave the office.
Example the standard check in timing is 9:00:00 AM and check out timing is 17:00:00 PM
Also as you can see in the above record the Userid 124 has checked in twice (124 26/08/2013 9:05:15 AM and 124 26/08/2013 9:05:20 AM), so it means I will require the first check in time which will be 26/08/2013 9:05:15 AM.