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 2
Rounding Time down 4
Numeric increment 4
Graph usage for times of day 0
Round time to nearest 15 minutes in decimal format 4
Rounding up to the nearest 6" increment 4
How do I round times to 15 minute increments? 2
Create database based on 24 hour time; 15 minute increments 1

Top