Hi All,
 
I have one small question(doubt) that how to subtract time.
 
Let me explain in detail:
 
I have one table, say "Test_Data" and I have three fields as follows:
 
1) EmpNo   Varchar(15)
2) dtDate    Date
3) tmTime   Time
 
This table will contain entry time as well as exit time for a perticual day for a perticular employee. Now here i want to calculate the total time employees worked for given two different dates  or two same dates, how do i achieve this.
 
 
Thanks In Advance.
 
 
Vishal Tiwari...
 
 
 
 
 


The INTERNET now has a personality. YOURS! See your Yahoo! Homepage. http://in.yahoo.com/

[Non-text portions of this message have been removed]