Share via

Limit entry to multiple of .25

Anonymous
2013-08-30T18:37:46+00:00

I have a file where users will enter the number of hours worked.  Is it possible to limit their entry to .25 increments?  If the user works from 8:00 to 9:15, they could enter 1.25. If they work 8:00 to 9:20, they would not be able to enter 1.33.

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Anonymous
    2013-08-30T18:48:56+00:00

    Use Data Validation on the cells - for example, select the cells - let's say that the first cell is E6 - and use the custom function

    =INT(E6*4)=(E6*4)

    That will allow any entry by 1/4 hours.

    You can also calculate the hours using time math:

    =ROUND((TimeOut-TimeIn)*96,0)/4

    like

    =ROUND((B6-A6)*96,0)/4

    Or to make sure they work full hours

    =ROUNDDOWN((B6-A6)*96,0)/4

    2 people found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2013-08-30T19:03:18+00:00

    Perfect!

    0 comments