I got it!!!!!!!!!!!!!! took a lot of work but this is how i got the
following12:01 am - 6:00 am = 16:01 am - 12:00 pm =.7512:01 pm - 6:00 pm
= .506:01 pm - 12:00 am = .25 Thank you Paul for your formula. if
((Time2Num(this.formattedValue) >= 36060001) &
(Time2Num(this.formattedValue) <= 57600001)) thenFactor.rawValue = 1
endif if ((Time2Num(this.formattedValue) >= 57660001) &
(Time2Num(this.formattedValue) <= 79200001)) thenFactor.rawValue =
.75endifif ((Time2Num(this.formattedValue) >= 79260001...
Hi Paul,thank you so much for your help. but i am doing something wrong.
it works on your form, but I cannot get it to work on mine. I changed
factor to my field name and am I supposed to change anything else?sorry
for the trouble.sara
Hi, I am trying to do a time calculationIf Time is between 12:01 am
-6:00 am then I would like the calculation to = 1Time is between 6:01 am
- 12:00 pm then I would like the calculation to = .75Time is between
12:01 pm - 6:00 pm then I would like the calculation to = .50Time is
between 6:01 pm to 12:00 am then I would like the calculation to = .25I
have looked at a lot of forums and I just cannot get this to work. I am
trying to calculate travel time. Please help.sara
Hi legallogic,What I would like it to click a check box and have a third
page appear. I know it is possible, but am not sure how. Could you help,
please?thankssara
Hi,I am creating a purchase form that has a table in it. What I would
like is for additional forms to automatically pop up when the total of
the order goes above 2500....or for the purchaser to click a box and
have these additional forms pop up. any ideas of the easiest way to do
this?thanks in advancesara