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

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

"Simples"!

Cheers,

Jarryd

"Jarryd" <(E-Mail Removed)> wrote in message
news:8A788E92-80FB-4AD2-A1A3-(E-Mail Removed)...
> 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