Custom validation rule - must be 15 increment of time
 

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

Custom validation rule - must be 15 increment of time
 

=INT(F13*96)/(F13*96)=1

"Simples"!

Cheers,

Jarryd

"Jarryd" wrote in message
...
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