3
Answers

How to find Total hours?

Santhosh K S

Santhosh K S

12y
1k
1
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............. 

Answers (3)
0
Abhishek  Jaiswal

Abhishek Jaiswal

NA 22.1k 5.1m 11y
use google forms, its easy and flexible too.
0
Pandu

Pandu

NA 18 13.2k 11y
I used radio buttons for displaying numeric and letter grade but either of them work not both. Secondly I am trying to get the class average which is not working.
0
venkata kumar

venkata kumar

NA 714 102.7k 11y
hi
tell me what error you getting