Divide the Value In column by other number

I want to divide each value in Column By 8 And store this value in days Upto 2 decimal…


This can be done it excel with this formula,

=ROUND((A2/8), 2)

Here A2 is my Actual Hours cell, so you need to change that alone and use this formula for that column.


But I want Only upto 2 decimal Point…

As @sarathi125 mentioned, Round function will let you control the decimal counts. Please find below link for more explanations

1 Like