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)) ...
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...
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 adv...