How can I obtain total hours of training for my department?

In the TargetSolutions platform, there is no option to calculate the total hours of training. However, you can export your report into an Excel spreadsheet and then calculate the hours with a simple formula. (Note: Your computer must have Microsoft Excel to produce the spreadsheet.)

Here is how it works:

1. Under the Administration tab, select Generate Reports.

2. Click the green Create New Report button. From the report type drop down select Completions Report or Completions - Aggregated Report

3. Once your report has run, you may click the Download button along the top and select  Spreadsheet (No Header). When you click this, an exported version of your report will be downloaded through Excel.

 Here is a sample report shown when selecting the Spreadsheet (No Header) option:

4. Note the column in which your Duration (hours) are located as highlighted above. In the sample report above, they are located in column E. In order to calculate the sum, you are going to highlight each entry in the column, as shown below. 

5. Finally, select the AutoSum button in the upper right corner of your spreadsheet, and your total sum should appear at the bottom of the Duration(hours) column.

Note: The final number at the bottom of your new column will be the total amount of training hours, which in this example is 253.