Data Import & Export

How to Export MS Project Resource Hours to Excel Without the 'H' Suffix

Natalie TaylorNatalie Taylor Nov 3, 2026 869 views

Question details

The user needs to export resource hour data from Microsoft Project into Excel without the 'h' unit suffix so the numerical values can be used for calculations.

How to Export MS Project Resource Hours to Excel Without the 'H' Suffix
Product
Microsoft Excel, Microsoft Project
Device & OS
not provided
Scenario
Exporting resource usage and timescale reports from MS Project into a spreadsheet for further data analysis and financial calculations.
Observed behavior
When timescale data is copied or exported to Excel, the values include an 'h' suffix (e.g., '8h'), which formats the cells as text and prevents mathematical operations.
Before you start

Ensure you have saved your Microsoft Project file before exporting data. If you plan to use the VBA macro method, check that your spreadsheet software's Trust Center settings allow the execution of macros.

Solution 1Recommended

Copy Data and Use Find & Replace

The fastest method is to manually copy the timescale data and use the Find and Replace tool in your spreadsheet to strip the 'h' characters.

This method works perfectly for quick, one-off reports where you only need to clean up the formatting after pasting the data.

1
Copy from Microsoft Project

Open the Task Usage or Resource Usage view in Microsoft Project, select the required daily timescale data, and copy it (Ctrl+C).

2
Paste into Excel

Open a blank Excel workbook and paste the copied data into the desired cells.

3
Open Find and Replace

Press Ctrl+H on your keyboard to open the Find and Replace dialog box.

4
Remove the 'h' suffix

Type 'h' into the 'Find what' field, leave the 'Replace with' field completely blank, and click 'Replace All'. The text strings will instantly convert to numbers.

Copy Data and Use Find & Replace
Data Format: Once the 'h' is removed, Excel will automatically recognize the remaining values as numbers, allowing you to run SUM formulas and PivotTables.
Effortless Data Cleanup

Process Exported Project Data Seamlessly with WPS Spreadsheet

WPS Spreadsheet is a lightweight, highly efficient tool for cleaning and analyzing exported Microsoft Project data. With blazing-fast Find & Replace and robust formula support, you can strip unwanted text suffixes and generate reports in seconds.

  1. 1. Paste Exported Data: Open a new workbook in WPS Spreadsheet and paste your copied timescale data from MS Project.
  2. 2. Open Find and Replace: Press Ctrl+H to quickly bring up the Find and Replace dialog box.
  3. 3. Remove Text Suffixes: Input 'h' in the 'Find' box, leave the 'Replace' box completely blank, and click 'Replace All'.
  4. 4. Calculate Data: Your data is now cleanly formatted as numbers. You can immediately apply SUM functions or create PivotTables.
100% compatibility with Microsoft Excel (.xlsx) formatsLightning-fast Find & Replace tools for instant data cleanupFamiliar user interface requiring zero learning curveFree and lightweight alternative for everyday data processing
microsoft office alternative - wps office

Frequently Asked Questions

Why does Microsoft Project add an 'h' to exported hours?

Microsoft Project includes the 'h' to explicitly denote 'hours' as the unit of work in its timescale views. When exported as raw text, this unit abbreviation comes along with the number.

Can I convert text strings with an 'h' into numbers using a formula?

Yes. If you prefer not to use Find & Replace, you can use the formula =VALUE(SUBSTITUTE(A1, "h", "")) in an adjacent column to strip the 'h' character and convert the remaining text into a calculable number.

Does removing the 'h' in Excel change the original Microsoft Project file?

No. Once the data is copied or exported out of Microsoft Project, it becomes entirely separate. Formatting the data in Excel or WPS Spreadsheet will not affect your original MS Project schedule.