Subject calculating sum of times
Author d_dude_2003
Hi folks,

I have the following table

ID Time1 Time2 TotalTime

Time1 and Time2 are posted by stored procedure. Then
in the end of processing i am doing

UPDATE MyTable SET TotalTime = Time2 - Time1

Am i right to assume that TotalTime will now hold the amount
of time passed since Time1 till Time2?

Now...I need to calculate SUM(TotalTime) for all records in a table..
And get the hours...How do i go about that?

Thanx alot.