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
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