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
