I am trying to make a database that tracks employee time. I was wondering if anyone knows the standard practice in doing so.

right now I have a "TimeIN" and "TimeOUT" both of which are "datetime" datatypes. what i am concerned about is whether or not to make another Column that is calculated to show total time worked for a single Transaction and then add it upto get Total hours worked for that day or if there is some other standard that is used.

TimeIN
TimeOUT
Break Paid 30 minutes only
TimeIN
TimeOUT
Lunch Paid 30 minutes only
TimeIN
TimeOUT
End Day.
Summary for that Day.

i think u creaed timein, timeout columns 3 time's try like this
timein
timeout
Tea break time
Aft T break Timein
aft T break Timeout
Lunch break
aft lunch timein
aft lunch timeout


suresh

well i feel to calculate single transaction hours there is no need to add new column if you need it in reports do calculation there

thanks......

Instead of maintaining the value of a physical column for this, create a "calculated column" to do the math for you. It will ALWAYS be up to date and the developers won't have to worry about doing the calculation right everytime in their code.

--Jeff Moden