Apply an FTE fraction to weekly hours

Multiply an FTE of 0.5 by a 40-hour full-time week to get 20 hours.

What you'll make

In Excel: 0.5 FTE of 40 hours becomes 20 hours.

The formula

The formula, with a numbered bracket under each part.
NumberPartWhat it doesResult so far
1A8The FTE, the share of a full-time week.0.5
2*Multiplies the two numbers.0.5 times …
3B8The full-time weekly hours.40, so 20

The result is weekly hours. Use the full-time hours your organization sets; 40 is only an example.

=A8*B8

How to use it

Yellow bar at the top? Click Enable Editing.

  1. See it work. The Example tab shows 20 made-up examples with the formula already in.
  2. Use your own numbers. Paste the FTE into column A and the full-time weekly hours into column B of the Template tab. The hours fill in by themselves.
  3. Move them into your letter. Copy the results. Then use Paste Special and choose Values.

Before you send

These are scheduled hours only. They don't decide who counts as full-time or who is eligible for benefits.