Subject How to do Time calculation
Author Vishal Tiwari
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.

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