Whether you need to submit proof of learning for performance reviews, track your annual professional development goals, or download a record of your completed courses, you can easily access and export your training history directly from My Learning.

This guide walks you through pulling your personal transcript in BizLMS and using Excel to total your completed training hours and filter by specific date ranges.

Part 1: Exporting Your Transcript from "My Learning"

1. Log in to BizLMS.

2. Click on My Learning in the main navigation menu.

3. Select the Completed tab (or History / Transcript tab) to view your full history of finished courses and content.

4. Click the Export button (usually located in the top-right corner of the list) and select Excel (.xlsx) or CSV.

5. Save and open the file on your computer.

Part 2: Calculating Your Total Completed Hours in Excel

Depending on your organization's settings, your export will show your completion duration as either decimal hours/minutes (e.g., 1.5 for 90 minutes) or standard time (HH:MM:SS).

Option A: If Duration is in Minutes or Decimal Hours

1. Scroll to the bottom of the column containing your course durations.

2. Click in an empty cell directly below your data.

3. Type =SUM( and select the range of duration cells above it (e.g., =SUM(C2:C25)).

4. Press Enter.

Note: If your report lists time in total minutes, divide the sum by 60 to convert to hours: =SUM(C2:C25)/60

Option B: If Duration is Formatted as HH:MM:SS (Hours:Minutes:Seconds)

Excel handles cumulative time differently when total hours exceed 24 hours.

1. In a blank cell below your duration column, enter the sum formula:

   Excel

    

   =SUM(C2:C25)
   

2. Right-click the cell with your total and select Format Cells.

3. Under the Number tab, choose Custom.

4. In the Type field, type [h]:mm:ss (the square brackets [h] ensure Excel totals all hours rather than resetting after 24 hours).

5. Click OK.

Part 3: Filtering Your Transcript by Date Range

If you only need to show hours completed during a specific timeframe (e.g., a specific quarter or performance review period):

1. Click on any cell in your table's header row (Row 1).

2. Go to the Data tab in Excel’s top ribbon and click Filter (or press Ctrl + Shift + L on Windows / Cmd + Shift + F on Mac).

3. Click the drop-down arrow in the Completion Date column header.

4. Select Date Filters:

   • Choose pre-set options like This Year, Last Quarter, or Year to Date.

   • Or select Between... to enter a custom start and end date.

5. Click OK.

Learner Pro-Tip: If you want your sum formula to automatically recalculate based only on the filtered rows visible on your screen, use =SUBTOTAL(9, C2:C25) instead of =SUM().