Custom validation rule - must be 15 increment of time

J

Jarryd

Hi,

I have been using this formula to round time values to the nearest 15
minute increment:
=ROUND(E10*96,0)/96

This works fine for cells where the value is auto-calculated. However, I
have one cell where a value has to be manually entered are strictly 15
minute increments? What I thought I might do is create a Data Validation
rule that checks to see if the value * 96 is an integer. If it isn't then
it fails. How would I do this? I know it can be done, I am just having a
bit of a block.

TIA,

Jarryd
 

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

rounding to closest 15 minute increment 1
Rounding Time down 4
Round time to nearest 15 minutes in decimal format 4
Creating a validation rule for numbers. 4
Time sheet validation 2
Rounding time 4
=time() IN 15 minute intervals 2
Time Calculation 1

Top