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
Do you mean you want to sum a Calculated Column, like I have done here with Calculated Amounts instead of Timedifferences:
http://ViewMaster365.com/vmsum
I presume Larry his method involves using a Workflow to write the Calculated value to a Number field, that way you can use the regular View settings of Totalling a Column.
Hi Keith.
So how did you do it? I am now thinking of trying to do it using a workflow. I think I might just work.
Thanks, Larry
Larry,
I made a list a while back. Â I use a workflow to calculate the time a process takes. Â It sounds like what I’ve done is a lot like what you’re trying to do. Â It took me a few tries to get it. Â It wasn’t easy. Â Send me a message some time and maybe we can do a Google Hangout and figure it out.
