AnsweredAssumed Answered

calculations

Question asked by dillard1 on Sep 19, 2018
Latest reply on Oct 5, 2018 by dillard1

Hello...... I hope all is well. Question...I need a report of hours sorted by week, I figured out that part. However, I need to only bill for any hours over 15 hours per week.  i.e. Robert Smith 40 hours - 15 hours = 25. so i would report 25 hours to be billed. If its under 15 hours i would like to just have it say "0" for billable hours. How do I do this? I have three fields a hours field(calculation field timeEnd-timeStart), s_weeklyTotal(Summary field =Total of hours)and finally billableHours(calculation field s_weeklyTotal- 15)? Any help/advice is appreciated.

Outcomes