I just started working with Designer and am trying to put together a time sheet for our office. I would like to use a formula to calculate overtime hours (in excess of 8 hours/day). I tried using "regulartime - 8" as my formula but if the regular time is less than 8 I show a negative number in the overtime column. This then affects my weekly totals. Is there a way to have any value of 0 or less than zero (negative) display as "0"?
Thank you for any help you can give.
(Chris.T), Jan 29, 2007 1:27 AM