Calculate sum of times in ASP 
Author Message
 Calculate sum of times in ASP

Hello,

A question, does anyone know how to sum up times in ASP?
I have a database with a table looking something like this:
beginCall  endCall   end         date
10:02:39     10:04:21  10:05:22  10-09-2001

I want to have the sum of all the time from beginCall to end during a day.
How do I get that? Surely there must be a time calculating thingy in ASP
that can do it for me?

Greets,
Sebastiaan.



Sat, 28 Feb 2004 17:04:52 GMT  
 Calculate sum of times in ASP
Hi,

I hope I didn't misunderstand you. You can use the combination of SUM and
DATEDIFF within a SQL statement to achieve what you wanted.

Regards,
Ben



Sat, 28 Feb 2004 20:51:07 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Summary: How to keep DB changes from being lost .. includes code.

2. calculate dates calculate time

3. Calculate sum of recordset

4. Calculate Sum Except When....

5. calculating sums in a table formated view !

6. Calculating binary check sum

7. How to calculate CRC check sum?

8. Calculate sums in a MSFlexgrid

9. Calculate Sum without including the suppressed field

10. SUMming of a calculated field

11. Calculate Sum of Pages

12. calculating the Sum(Urgent)

 

 
Powered by phpBB® Forum Software