Years ago, I setup an InfoPath form for an approval process. There are around 7 status changes during the duration of this form. We wanted to be able to see how long a request would take from creation to approval. This was actually pretty simple. All that you need is a calculated column. Follow these steps and you will be able to time an event/process.
Create Calculated Column (Form Duration)
Enter this for the formula: =TEXT(Modified-Created,”h:mm”)
That’s it! The calculation will look at the fields provided in the formula. The time will then calculate based on how long it took from creation to when it was last modified. If you have a form that hides a submit button based on a status, you will then be able to lock down the time calculation.
Go to the list or library that you want to resize and add a Content Editor Web Part.
From the script below, I am referencing jQuery from my internal site.
Follow these steps and your will be highlighting in no time!!!
Go to your list to be highlighted
Add a Content Editor Web Part
Move the CEWP to the bottom of the page
Click the Edit Source button
Copy and paste the following lines of code into the source code section
if (x[i].innerHTML==”Next Day Pickup”) //find the data to use to determine the color
x[i].parentNode.style.backgroundColor=’yellow’; // set the color
Make your changes to the innerHTML section to reflect the list value for the jquery lookup
Set the color of your choosing. You can also choose to use the html value for the color: FFFFOO
Please note, I am referencing jquery inside of my SharePoint site. This way, I do not have to add an external reference.