AnsweredAssumed Answered

Getting StartTime and Endtime from TimeStamp Field but DateWise

Question asked by ShaikhAtta on Aug 26, 2013
Latest reply on Aug 27, 2013 by philmodjunk

Title

Getting StartTime and Endtime from TimeStamp Field but DateWise

Post

     Hello I have a table with fields :

     UserId        TimeStamp

     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.

      

Outcomes