How to find Total hours?

Question

i'm new to SQL ecpeialy on DATE related operation

In my table  starttime and  endtime two columns are there, i need to find sum of total hours group by employeename.
how can i do this?

 exm:  EmpName            Starttime                   EndTime
          A         14/2/2012 25:20:00   14/2/2012 25:20:00
          A         15/2/2012 20:20:00   15/2/2012 25:20:00

But i need output as
                 EmpName TotalHours
                      A          20:25:32(eg)
please help............. 

Answer 1

Dear try this


Select UserCode,
Cast((DateDiff(mi,Starttime,EndTime) / 60) As Varchar(8)) + ':' +
Cast((DateDiff(mi,Starttime,EndTime) % 60) As Varchar(2)),Starttime As [In Time],EndTime  As [Out Time ]From tblLogIn

Answer 2

Hi,

Note that when you use the HH will give the date difference in hours. But it needs something like entire different between two dates.

I think get the seconds or minutes and find the differences, so you can calculate the actual time different by diving the minutes.

Answer 3

Hi
use datediff like

select

sum(Datediff(hour,StartingDate,EndingDate)) from ItemDiscount