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

# Separating Total time into Straight Time & Overtime

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

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.