Skip navigation

Author Archives: Jaime Prado

How can I export time from a single task to Excel?

A customer asked the following question: Is there a way to extract the time logged for a single task that exists outside of reports? Time can be exported from any task directly from the its view page. To download an Excel file, scroll down to the bottom half of the task and click to reveal […]

HTML Decode a String in Excel, No Plugins Required

This function converts an HTML encoded string to its regular text representation without having to install third party plugins. Public Function HtmlDecode(StringToDecode As Variant) As String     Set oMSHTML = CreateObject(“htmlfile”)     Set e = oMSHTML.createElement(“T”)     e.innerHTML = StringToDecode     HtmlDecode = e.innerText End Function To add it to Excel: 1. Type ALT+F11 2. In the File menu […]

Don't have an Intervals account? Start your own unlimited trial.

No credit card required. No software to install. Cancel any time.

Try it Free