How to Export MS Project Resource Hours to Excel Without the 'H' Suffix
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.

- 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.
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.
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.
Open the Task Usage or Resource Usage view in Microsoft Project, select the required daily timescale data, and copy it (Ctrl+C).
Open a blank Excel workbook and paste the copied data into the desired cells.
Press Ctrl+H on your keyboard to open the Find and Replace dialog box.
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.

Export Using Visual Reports
Use Microsoft Project's built-in Visual Reports feature to generate an Excel PivotTable that organizes the data more cleanly.
Use a VBA Macro for Custom Layouts
For maximum control over the daily layout and automatic stripping of suffixes, run a custom VBA script in MS Project.
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. Paste Exported Data: Open a new workbook in WPS Spreadsheet and paste your copied timescale data from MS Project.
- 2. Open Find and Replace: Press Ctrl+H to quickly bring up the Find and Replace dialog box.
- 3. Remove Text Suffixes: Input 'h' in the 'Find' box, leave the 'Replace' box completely blank, and click 'Replace All'.
- 4. Calculate Data: Your data is now cleanly formatted as numbers. You can immediately apply SUM functions or create PivotTables.

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.




