Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
validation rule | Excel Programming | |||
Validation Rule | New Users to Excel | |||
Validation rule - custom 5 digits w/ leading zeroes | Excel Worksheet Functions | |||
Validation rule | Excel Discussion (Misc queries) | |||
validation rule | Excel Worksheet Functions |