10 Replies Latest reply on Dec 14, 2015 1:11 PM by Muralidhar Areti

    Sort by Time in DateTime Data Type

    elizabeth.gancas

      Hi All,

       

      I have Date& Time data for each employee punching in and out by day. I have a min([Punch In]) and a max([Punch Out]) because each employee punches in and out twice in a day. Once in the morning, once for lunch, once back in after lunch, and when they leave at the end of the day.

       

      I would like to sort by time.

      punch in_out example.png

       

      Any suggestions?