Results 1 to 3 of 3

Thread: Time tracking.

  1. #1
    Join Date
    Apr 2006
    Posts
    1

    Unanswered: Time tracking.

    I think I am making something difficult that really shouldn't be. Our employees clock in and out and the time is recorded to a SQL 2000 database. I have been asked to pull the time that each employee works per shift. I can't seem to figure out how to split the time the employee was there into the 3 shifts for the day.

    1st 07:00 - 14:59
    2nd 15:00 - 22:59
    3rd 23:00 - 06:59

    I know I am just missing something basic here. If anyone could just point me in a general direction it would be greatly appreciated.

    Thank you.

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    What datatpye are you using to store the times?
    Can you post the table definition, sample data and required output?

    Moved to Microsoft SQL Server topic.
    George
    Home | Blog

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    DateDiff()

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •