Problems Concatenating a calculated column

Hi All

I am having problems Concatenating a calculated column.

• The calculated column calculates subtract “End Time” from “Start Time”.
• The calculated column is named “Total Hours”.
• The first row output is in the correct format that being HH:MM:SS or “10:10:10”.
• However, the next row is rounded up as an integer or “10”.
• This is because “The data type returned from this formula is:” selected “Number (1, 1.0, 100)”.

However, when I select “Date and Time” for the “The data type returned from this formula is:” the CONCATENATE formula does not work.

Attached, is the jQuery script that I am using (pasted in the .aspx page). I believe that the “parseInt” I am using is resulting in the integer output. I have tried “parseFloat” and “Date.parse” but this doesn’t calculate the running total.

Do you guys have any ideas?

Thanks, Larry