I have a table with 3 columns with multiple data rowEmpId , PUNCHED_IN_OUT StatusDOE001, 2014-05-23 9:56:01DOE001, 2014-05-23 18:08:45I've tried datediff(min,MIN(punched_in_out),MAX(punched_in_out))the above rounds to 9 hours also this datediff(min,MIN(punched_in_out),MAX(punched_in_out)) % 60different result
and this 18:07-9:56 result = 8:51 when the actual result should be 8:03
Please note that the subtracting the Last punched time minus the first punched time
does not work every time
Please helpThanks