How to convert hours to 8-hour work days in Excel?
Using Efficient Tabs in Excel Like Chrome, Firefox and Safari! Save 50% of your time, and reduce thousands of mouse clicks for you every day! To change the hours to normal work days, you can apply the following formulas, please do as this: Enter this formula: =QUOTIENT (A2,8)&" days "& ( (A2/8)-QUOTIENT (A2,8))*8&" hours " into a blank cell where you want to get the result, and …
DA: 40 PA: 8 MOZ Rank: 6