Covert hours to days (XP)

ishtere a custom format i can use to convert the numbers in cells to days, e.g a cell contains number 55 to represent the number of hours a task took. Can we apply a format that will day it took 2.4 days?

Re: Covert hours to days (XP)

Re: Covert hours to days (XP)

You may not have to enter the formula in each cell individually. If the cells are in a column, you can enter the formula in the cell next to the first one, and fill down as far as needed. Copy and paste will work too.