Hi,
I was considering creating a report for calculating payroll hrs for both "regular" time and "Overtime". Can someone please help me out with the formula i would need to use. Basically how would i translate the following logic into a language crystal understands:
Calculate "Regular" time:
(For Weekdays only) : if Payroll hrs > 8 then 8, else Payroll hrs.
// in this way i will get 8 hrs for regular time if employee worked greater than 8 hrs and will need to calculate overtime in the next formula)//
Calculate "Overtime":
If weekend then the payroll hrs, else if payroll hrs > 8 then Payroll hrs - 8, else 0.
// in this way if it's a weekend then the entire payroll hrs will be overtime, if not a weekend and if payroll hrs are greater than 8 hrs then give me payroll hrs - 8 hrs, else just give me payroll hrs.//
Thank you all for your help in advance to help a noobie....By the way, if you find any error in the logic, please let me know or if there is a simplified way.
IP Logged