hi there ,

i have a table that include the next fields :
1. EventID
2. StartTime
3. EndTime

i want to sum (EndTime-StartTime) but there is a problem !!!
4 eg. if i m adding 12:00 to 11:00 i get 23:00 , so far so good ! BUT if i m adding 12:00 to 13:00 i get 1:00 Not so good !!!

my question is how to add time and recive the correct sum value ?

tnx lirlir