Numeric increment

A

Annette

I need to create a form for users to enter the amount of time they
spent on a project. We are not interested in entering beginning and
ending times, just the total time spent on the work, however times can
only be in 15 minute increments. Therefore, the decimal portion of the
number can only be .25, .50 or .75. How can I force the 15 minute
numeric increment equivalent in a numeric field?
 
B

Bob Darlington

Hi Annette,
Try using the 'Mod' operator.
In the before update event of the field:
If fldMinutes Mod 15 <> 0 then
msgbox ..
Cancel = -1
 
J

James A. Fortune

I need to create a form for users to enter the amount of time they
spent on a project. We are not interested in entering beginning and
ending times, just the total time spent on the work, however times can
only be in 15 minute increments. Therefore, the decimal portion of the
number can only be .25, .50 or .75. How can I force the 15 minute
numeric increment equivalent in a numeric field?
Click to expand...

To the left of the "Search this group" button, type "quarter hour
validation," then click on the button. Click on the first link
returned.

James A. Fortune
(e-mail address removed)
 
C

Clif McIrvin

I need to create a form for users to enter the amount of time they
spent on a project. We are not interested in entering beginning and
ending times, just the total time spent on the work, however times can
only be in 15 minute increments. Therefore, the decimal portion of the
number can only be .25, .50 or .75. How can I force the 15 minute
numeric increment equivalent in a numeric field?
Click to expand...

To the left of the "Search this group" button, type "quarter hour
validation," then click on the button. Click on the first link
returned.


Real helpful reply for those of us on USENET :)
 

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

Time input by work order 1
How to increment the numeric portion of a text field 3
=time() IN 15 minute intervals 2
Custom validation rule - must be 15 increment of time 1
Creating a validation rule for numbers. 4
EXCEL time match 3
Excel Rounding Up to Nearest Multiple 2
Increment Alpha/Numeric String 4

Top