Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to get a Total for Regular and Overtime hours

Status
Not open for further replies.

RoxSki

Technical User
Dec 20, 2012
6
0
0
I am attempting to convert our company's payroll to Crystal version 11.5.12.1838. I am not a pro at Crystal but I do know more than just basic reporting. I have to use a formula for pay hours (not just the pay hours field). I can't seem to get the
Reg Hours: (if Sum ({laborhed.payhours}, {laborhed.clockindate}, "weekly")>40 then 40 else Sum ({laborhed.payhours}, {laborhed.clockindate}, "weekly"))
and the
Overtime Hours: if Sum ({laborhed.payhours}, {laborhed.clockindate}, "weekly")>40 then Sum ({laborhed.payhours}, {laborhed.clockindate}, "weekly")-40 else 0
to add together! I have read posts and forums.....
How to I get the weekly totals to add together for a grand payperiod total for Reg and OT?
please help.
 
forum767?

Skip,
[sub]
[glasses]Just traded in my old subtlety...
for a NUANCE![tongue][/sub]
 
thanks, more forums to look thru.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top