List:General Discussion« Previous MessageNext Message »
From:Douglas Brantz Date:July 15 1999 1:38pm
Subject:total seconds worked
View as plain text  
Found the command with help from friends, thanks again

To total up each users total time I used this statement:
 select SEC_TO_TIME(sum(outtime-intime)),lastn,firstn from monitor where

lastn=lastn and firstn=firstn group by lastn;
+----------------------------------+--------+---------+
| SEC_TO_TIME(sum(outtime-intime)) | lastn  | firstn  |
+----------------------------------+--------+---------+
| 00:01:26                         | blow   | Joe     |
| 00:00:33                         | Brantz | Douglas |
| 01:31:25                         | books | kevin   |
| 00:00:43                         | canel  | joe     |
| 03:01:55                         | CHEY | WES     |
| 01:45:16                         | Chuck | Jason   |
| 01:59:45                         | Shawn   | Travis  |
| 00:00:11                         | steve  | bob     |
+----------------------------------+--------+---------+

thanks again,

Douglas

--

Douglas Brantz
Computer Consultant
Fine & Applied Arts
Appalachian State University
Boone, NC 28608

828-262-6312 FAX
828-262-6549 OFFICE
brantzdr@stripped


Thread
total seconds workedDouglas Brantz15 Jul