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.

2 Likes

But I want Only upto 2 decimal Point…

@Shubham_Akole

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

1 Like