Number of Part-time Employees (Historical)

Returns the count of part-time employees reported by the company for a historical period. Part of workforce composition analysis.

Notes

  • Not all companies report this metric
  • Definition of part-time varies by company/region
  • Compare with full-time employee count
  • May return NA for companies that don't disclose

Syntax

=hf_Number_of_Part_Time_Employees(Symbol, Year, [Quarter], [TTM])
Excel Desktop (Windows)

Examples

Annual data for 2023
=hf_Number_of_Part_Time_Employees("MSFT", 2023, 2)
Q2 2023 data
Last quarter
Last year
Cell references

When to Use

Workforce analysis, labor cost modeling, operational efficiency analysis

When NOT to Use

| Need total employees | Look for total employee functions | | Need sales per employee | hf_Sales_per_employee() |

Common Issues & FAQ

What year formats are accepted?

Use numeric years (2023) or period codes: lq (last quarter), ly (last year), lt (last twelve months), lq-1 (quarter before last).

Why am I getting "NA"?

The company may not report this metric, or data may not be available for the requested period.

What's the difference between quarterly and TTM?

Quarter shows one quarter's data. TTM (trailing twelve months) sums the last 4 quarters.

Get Access to 1 Billion Usable Market data points IN YOUR EXCEL SHEETS WITH EASY TO USE EXCEL FUNCTIONS

Get started today
MarketXLS Excel Add-in Tutorial - How to Use Number of Part-time Employees (Historical) and Other Financial Formulas
How does MarketXLS work?