Solved

# Combining 2 columns in SharePoint List

Posted on 2011-09-22
283 Views
Last Modified: 2012-05-12
I have the following Sharepoint list,  It needs to be grouped by month, then I need to total the duration for each month. Duration is a calculated column of (End Time - Start Time).

Can someone help me how can I get the Total after each month.

Start Time                End Time                             Duration

Month   : August ¿(1)
XXX      Sys Admins 8/17/2011 12:00 AM      8/18/2011 12:00 AM      1,440
Month   : October ¿(1)

XXX      Sys Admins 10/6/2011 12:00 AM      10/7/2011 12:00 AM      1,440
Month  : September ¿(1)

XXX      Sys Admins 9/15/2011 12:00 AM      9/15/2011 3:00 AM      180
0
Question by:nsdlsandy
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points
• Learn & ask questions
• 3
• 2
• 2
7 Comments

LVL 13

Assisted Solution

George K. earned 100 total points
ID: 36586230
First you change your view and add grouping by the month field.
Then you choose the column for which you need to sum.
0

LVL 13

Expert Comment

ID: 36586238
Have you reied the above?
0

LVL 14

Expert Comment

ID: 36587261
Do you already have the Month field? If not create a calc column called month and set the formula to =TEXT([Start Time],"mmmm"). Then create a view and set group by to this calc month filed.
0

LVL 1

Author Comment

ID: 36597014
So the list above is already grouped by month, I do have month view too..duration above is calculated column of end time - start time and they can be numerous within a month, and I don't get the option to do total on a calculated column.

My question is how to get the total of various durations within a month.
If I am missing something than can you please show mw in this or any other example.

Thanks,
SM
0

LVL 14

Accepted Solution

abhitrig earned 400 total points
ID: 36599212
If i understand you correctly, you are looking for the sum of all duration for sysAdmin in  a month.

So ideally you need a group by month, then dept(sysAdmin) and then duration.
http://techtrainingnotes.blogspot.com/2008/11/sharepoint-group-by-on-more-than-2.html

Or you can play around with xslt to display the totals...
http://geekswithblogs.net/SoYouKnow/archive/2010/03/30/sharepoint---summing-calculated-columns-by-groups-dvwp.aspx
0

LVL 1

Author Comment

ID: 36710223
Thanks I had looked at the techtrainingnotes link earlier and was not getting the right result but the second link has helped me a little with that. Thanks for those. Do you anything which can help me conditional formatting the cells?
Thanks,
SM
0

LVL 14

Assisted Solution

abhitrig earned 400 total points
ID: 36711918
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

### Suggested Solutions

Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
Simple Linear Regression
###### Suggested Courses
Course of the Month2 days, 17 hours left to enroll

#### 752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.