|formula to change minutes to hours in excel||0.85||0.8||2738||94|
How to Count Hours Worked in Excel. Change the cell format to hours by selecting the cell and clicking on the arrow next to the "Number" option, which is on the "Home" tab. Select the "Custom" option, and type "h" into the "Type" field to change the cell format to hours. Enter the formula "=TEXT (B2-A2,"h")" to do this directly within the formula.