Time tracking on sharepoint list

Question

_{Thursday, December 31, 2015 11:39 AM}

All, 

I am using a SharePoint list to keep track of a series of projects. Every time I work on a project I edit one of the task fields (free text field I created) with updates.

Now I was asked to track the time I spend on each project per month. I understand this is a different level... time-sheets, but do you think of any trick or smart way I could track the activity time within a task by creating/adding a new field or something?

Thank you

All replies (4)

_{Friday, January 1, 2016 7:55 AM ✅Answered}

Hi Larbac,

There is no OOB way to achieve your requirement.

A solution can be like this:

You can create a new list to store the time users spent and the corresponding user names. In the task list, you monitor operations users did and get the date, e.g. get the date both when users click edit button and when users click save button, then store the date and do some calculation in the new list.

It won't be an easy job to make all these things working together, therefore, a fact you might want to take into consideration is that more time and effort would be required.

Best Regards,

Dean Wang

TechNet Community Support
Please remember to mark the replies as answers if they help, and unmark the answers if they provide no help. If you have feedback for TechNet Support, contact [email protected].

_{Thursday, December 31, 2015 1:06 PM}

Hi Larbac,

You can do that using calculated columns.

Add new calculated columns and insert below formula

=TEXT([Column2]-[Column1],"h:mm")

In your case probably Columns2 is Modified Date and Columns1 is Created Date

For formula refer

https://msdn.microsoft.com/en-us/library/office/bb862071%28v=office.14%29.aspx#sectionSection2

for adding calculated columns refer

http://sharepoint.rackspace.com/calculated-columns-tutorial

_{Thursday, December 31, 2015 1:11 PM}

Thank you Jaydev.

If I understand correctly, when using your suggestion I will get the total time for that task. Which is ok. But this does not allow me the monthly breakdown.

I can have a task open for months. And have weekly updates...

_{Thursday, December 31, 2015 2:09 PM}

Larbac Try this if it works

Create 2 calculated columns

Column1 => if Month in Column1 is Different than current month or Null then Copy Modified Date to Column1, so Column1 will contains time and Date on which you 1^st modify task in that month.

Column2 => Column1- Current Modified Date.

Note.This will not solve scenario where you modify task only once in months.