July 14, 2008 at 2:25 am
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
July 14, 2008 at 3:31 am
Please post with more details. You have given only Date ,whether it denotes start date or end date or both.
karthik
July 14, 2008 at 3:34 am
[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?
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply