You can use the following formulas to convert a number of hours to 8-hour workdays in Excel:

**Formula 1: Return Number of Workdays as Decimal**

=B2/8

This particular formula converts the hours in cell **B2** into the number of 8-hour workdays as a decimal.

For example, if cell **B2** contains **45 hours** then this formula will return **5.625 workdays**.

**Formula 2: Return Number of Workdays as Days and Hours**

=QUOTIENT(B2,8)&" days "&((B2/8)-QUOTIENT(B2,8))*8&" hours"

This particular formula converts the hours in cell **B2** into the number of 8-hour workdays as days and decimals.

For example, if cell **B2** contains **45 hours** then this formula will return **5 days 5 hours**.

The following examples show how to use each method in practice with the following dataset in Excel that shows the number of total hours worked by various employees at some company:

**Example 1: Return Number of Workdays as Decimal**

We can type the following formula into cell **C2** to convert the number of hours in cell **B2** into a number of 8-hours workdays as a decimal:

=B2/8

We can then drag and fill this formula down to each remaining cell in column C:

Column C now displays the number of working days as a decimal for each number of hours in column B.

For example:

**45**hours is equal to**5.625**8-hour work days.**40**hours is equal to**5**8-hour work days.**80**hours is equal to**10**8-hour work days.

And so on.

**Example 2: Return Number of Workdays as Days and Hours**

We can type the following formula into cell **C2** to convert the number of hours in cell **B2** into a number of 8-hours workdays as days and hours:

=QUOTIENT(B2,8)&" days "&((B2/8)-QUOTIENT(B2,8))*8&" hours"

We can then drag and fill this formula down to each remaining cell in column C:

Column C now displays the number of working days and hours for each number of hours in column B.

For example:

**45**hours is equal to 5 8-hour work days and 5 hours.**40**hours is equal to 5 8-hour work days and 0 hours.**80**hours is equal to 10 8-hour work days and 0 hours.

And so on.

**Additional Resources**

The following tutorials explain how to perform other common operations in Excel:

Excel: How to Convert Time Duration to Minutes

Excel: Calculate Difference Between Two Times in Minutes

Excel: Calculate Difference Between Two Times in Hours