1 Reply Latest reply on Dec 18, 2012 9:13 AM by comment

    Separating Total time into Straight Time & Overtime

    BarCab78

      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?

        • 1. Re: Separating Total time into Straight Time & Overtime
          comment

          BarCab78 wrote:

           

          What functions or calculation can I use to separate a Total Duration into Straight Time hrs and Overtime hrs?

           

          Assuming Duration is a time field, and sTotalDuration is a summary field = Total of Duration, try :

           

          Straight Time =

          Min ( GetSummary ( sTotalDuration ; Date ) ; 28800 )

           

          Overtime =

          Max ( GetSummary ( sTotalDuration ; Date ) - 28800 ; 0 )

           

           

          Result is Time for both.