Skip to content
English
  • There are no suggestions because the search field is empty.

How to Create an Hours Report in PSOhub

Learn how to build, filter, and export a custom hours report to analyze time entries, billable hours, and labor costs in PSOhub

Published: 1 June 2026

Audience

  • Admin

  • Controller

  • Project Manager

Objective

This article explains how to create an hours report in PSOhub by filtering time entries, customizing columns, and exporting the data to Excel for further analysis.

Prerequisites

Eligible access
        You must have Admin, Controller, or Project Manager access in PSOhub.

Steps

  1. In the main menu, navigate to Time & Expenses > All Hours to report on hours across your organization.
  2. Alternatively, you can report on hours for a specific project by opening the project's Hours tab and following the same steps below.
  3. Click Edit Columns in the top-right corner to select which columns to display and set their order.
 ⚠️ Important: The column order and visibility you set here directly affects your Excel                     export. Columns that are hidden will not appear in the export, and the order of                           columns in the export matches the order shown on screen. Set your preferred column             layout before exporting to ensure consistency. 

 

        3.   Use the filters at the top of the grid columns to narrow the data to the time entries you want                   to report on. You can click Clear Filters when needed.

        4.   Click Export.

        5.   Open the downloaded file from your browser to view the report in Excel.

Working with Excel Functions

When exporting hours from PSOhub, certain fields are formatted as text by default, which prevents Excel formulas such as SUM() or AVERAGE() from working directly on them. These fields include:

  • Hours
  • Selling Rate
  • Total Amount
  • Total Cost Rate Base
  • Total Selling

To perform calculations in Excel without manually converting data types, use the following numeric-formatted fields available in the export:

Field Use instead of
Hours (Excel) Hours
Total Amount (Excel) Total Amount
Total Amount Cost Rate Base (Excel) Total Cost Rate Base
Total Amount Base (Excel) Total Amount Base
Total Selling (Excel) Total Selling
   Cost Rate (Excel)    Cost Rate
   Cost Rate Base (Excel)    Cost Rate Base
   Base Selling Rate (Excel)    Base Selling Rate

 

💡 Tip: Always use the (Excel) version of a field when you plan to perform calculations in              your exported spreadsheet.

Result

Your hours report is downloaded as an Excel file containing the filtered time entries and selected columns. You can follow these same steps to create an hours report both from the Time & Expenses module and the Hours tab of a project. Use the (Excel) numeric fields for accurate calculations across hours, amounts, and costs.

Next Steps

✅ Create an Expenses Report
Export expense entries across your projects to analyze costs by category, project, or user.
How to Create an Expenses Report in PSOhub

✅ Approve time entries
Review and approve submitted hours before they are included in invoices or reports.
Approval By Project Manager: How to Review and Approve Hours

✅ Generate an invoice from booked hours
Convert approved time entries into a billable invoice for your client.
Manual Invoicing of T&M and Expenses in PSOhub

Related Articles