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

The formula

| Number | Part | What it does | Result so far |
|---|---|---|---|
| 1 | A8 | The FTE, the share of a full-time week. | 0.5 |
| 2 | * | Multiplies the two numbers. | 0.5 times … |
| 3 | B8 | The 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*B8How to use it
Yellow bar at the top? Click Enable Editing.
- See it work. The Example tab shows 20 made-up examples with the formula already in.
- 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.
- 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.
Microsoft's help: Calculation operators in Excel
OTHER ROUTES YOU MIGHT LIKE

Turn fraction fields into a number
3 and 4 → 0.75; 3 and 0 → Review zero denominator
Get the template →
Get the fraction part, keeping its sign
-1.5 → -0.5
Get the template →
Round values to the nearest fraction
0.26 to the nearest 1/4 → 0.25
Get the template →
Merge a few test letters before the whole mailing
Whole mailing → records 2 to 4 only
Take this route →