I have created a DB in MSSQL and a couple of forms in Infopath 2003

The problem form retrieves the info from the MSSQL database and puts it in a
repeating table and i can run queries to show only the relevant data but the
main purpose of the form is to get who took the longest or shortest time per
task or day or Activity.

eg..

Date           | Name     | TIME Taken | Activity

1-Jan-2003  | Jim         | 00:15          | Invoicing

4-Jan-2003  | Tony       | 00:35          | Labelling

7-Jan-2003  | Jim         | 01:00          | Invoicing

                                  01:40  - - - Total Time Taken

The problem is when i try to calculate the Sum of the Time taken it gives a
(1.#QNAN) error.



I have tried the Infopath Blog  
http://blogs.msdn.com/infopath/archive/2007/02/21/calculating-elapsed-time-witho
ut-code.aspx

But that didnt work just wondering if im doing something wrong or if the
fact that MSSQL store additional irrelevant info such as the date field i
enter gets a time assigned (00:00) and the time field gets a Date assigned
even thoug i dont use those parts could they be affecting the calculation.