calculating hours worked

• s_lamani

  SSC Journeyman

  Points: 75

  More actions

  July 14, 2008 at 2:25 am

  #72761

  Hi i am having table with emp code and transaction,i want to calculate how many hours he worked for the day

  format of table

  iddate

  72068/14/06 5:01 PM

  72088/14/06 5:02 PM

  72068/14/06 5:03 PM

  72068/14/06 5:08 PM

  72068/14/06 5:09 PM

  72078/14/06 5:06 PM

  72078/14/06 5:14 PM

  72098/14/06 5:20 PM

  72098/14/06 5:16 PM

  72088/14/06 5:24 PM

• karthik M

  One Orange Chip

  Points: 29139

  More actions

  July 14, 2008 at 3:31 am

  #842249

  Please post with more details. You have given only Date ,whether it denotes start date or end date or both.

  karthik

• goodguy

  SSCertifiable

  Points: 5456

  More actions

  July 14, 2008 at 3:34 am

  #842254

  [Code]Hi i am having table with emp code and transaction,i want to calculate how many hours he worked for the day.

  Format of table

  id date

  7206 8/14/06 5:01 PM

  7208 8/14/06 5:02 PM

  7206 8/14/06 5:03 PM

  7206 8/14/06 5:08 PM

  7206 8/14/06 5:09 PM

  7207 8/14/06 5:06 PM

  7207 8/14/06 5:14 PM

  7209 8/14/06 5:20 PM

  7209 8/14/06 5:16 PM

  7208 8/14/06 5:24 PM[/Code]

  1. Why are there multiple rows for some "ID" values?

  2. What time does the column "date" refer to: TimeIn or TimeOut?

  3. Where is the other time column?

  ---

  Regards,

  goodguy

  Experience is a bad teacher whose exams precede its lessons