Azim says:
You want output in this way?
Please share the database table name, structure (i.e. columns) and some sample data
So that I can build some sample and give it to you
Acctually Problem Solved By this Query..
SELECT EmployeeInDate, EmployeeLunchOutTime, EmployeeLunchInTime, (CINT(LEFT(EmployeeLunchInTime, 2)) - CINT(LEFT(EmployeeLunchOutTime, 2)))
* 60 + CINT(RIGHT(EmployeeLunchInTime, 2)) - CINT(RIGHT(EmployeeLunchOutTime, 2)) AS D
FROM EmployeeLog
EmployeeInDate __ Date/Time
EmployeeLunchOutTime __ Time In String Format (Eg. 13:55)
EmployeeLunchInTime __ Time In String Format (Eg. 14:55)
Output: InTime - OutTime
EmployeeIndate ELOTime ELInTime Difference
| 05-Jul 2014 12:00:00 AM |
13:15 |
14:30 |
75 |
| 06-Jul 2014 12:00:00 AM |
13:19 |
14:15 |
56 |
| 07-Jul 2014 12:00:00 AM |
13:01 |
13:35 |
34 |
| 08-Jul 2014 12:00:00 AM |
13:48 |
14:15 |
27 |
| 09-Jul 2014 12:00:00 AM |
13:05 |
13:45 |
40 |
| 10-Jul 2014 12:00:00 AM |
13:09 |
13:46 |
37 |
| 11-Jul 2014 12:00:00 AM |
13:12 |
14:13 |
61 |
| 10-Jul 2014 12:00:00 AM |
13:00 |
13:30 |
30 |
| 10-Jul 2014 12:00:00 AM |
12:55 |
13:45 |
50 |
| NULL |
NULL |
NULL |
NULL |
