Home Forums SQL Server 2005 Development Converting sequential time records into IN and OUT times RE: Converting sequential time records into IN and OUT times

  • Hi Jeff,

    Lobbying for a change in the clock design is not an option at present. I am stuck with this clock and I now have to work out a way for calculating hours worked with what I have. With the tips i got from you and @pietlinden I have been able to calculate the minutes worked in a day -first punch to last punch. I am still trying to find a way of calculating the time difference between successive IN and OUT punches. Once this is done, I will need to add all of these for a day together to get the actual time worked in a day. Then comes the calculation of normal time, overtime and double overtime.. but that is not too difficult once I get to an accurate computation of hours per day.

    I would appreciate some pointers on how to achieve this.

    cheers

    Sudarshan.