5 Replies Latest reply: Jul 16, 2015 4:35 AM by hana alsaleh RSS

    time sheet

    hana alsaleh

      i have to create time sheet table .

       

      I have table with filed

      Personal no (Text)

      Personal Name (text)

      EventTime (Timestamp)

       

      what i already have

      Personal NoPersonal nameEventTime
      111Hana8.00 AM 12/7/2015
      111Hana4.00 PM 12/7/2015
      112Mohammed8.00 AM 12/7/2015
      112Mohammed10.00 Am 12/7/2015
      112Mohammed1.00 PM 12/7/2014
      112Mohammed5.00 PM 12/7/2015

       

       

      what i want to do , how can i make time in , time out

       

      Personal NoPersonal nameTime InTime OutTotal Hours
      111Hana8.00 AM4.0 PM8 hours
      112Mohammed8.00 AM5.00 PM6 Hours ( He left from 10 to 1 , take first in and last out per day )

       

      and the search will be in date from filed Timestamp