AnsweredAssumed Answered

Separating Total time into Straight Time & Overtime

Question asked by BarCab78 on Dec 18, 2012
Latest reply on Dec 18, 2012 by comment

How do I go about calculating overtime on a Summary Part? I have a simple database with a Date field, In & Out time fields and a calculation field for duration between time punches. I have a report which summarizes by Date and summarizes Duration per day in a summary field. How do I separate a day with multiple punches totalling 10 hrs into two fields, 8 hrs straight time and 2 hrs overtime on the Summary Part. What functions or calculation can I use to separate a Total Duration into Straight Time hrs and Overtime hrs?