How do I set up a time sheet using the 7/8 rounding rule?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am setting up a time sheet that has to utilize the 7/8 rounding rule. How
do I calculate the rounding?
 
One possible way

=ROUND(A1/(1/96),0)*(1/96)

with the time value hh:mm in A1
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formula/version 2007 2
TimeSheet Using 100 Minutes & Rounding to .25 2
Time Sheet Function 3
Rounding Up question 2
rounding the results of two times 5
Daily Time Sheets with Rounding 1
How do I apply a rounding rule 13
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12

Back
Top