Sep 03 2022 06:18 PM - edited Sep 03 2022 06:20 PM
I want to calculate the payment per day worked, this is calculated per hour worked plus overtime, bonus per working day and fuel allowance.
Time In - Time Out = Working hours X pay per hour + Overtime hours X +25% of pay per hour + adicional pay for nigth (calculate between 22:00 - 5:00) + bonus per working day + fuel aid per day.
I know some formulas but within the month they are all activated at the same time including Saturday and Sunday, I would like them to be activated only on the day worked.
please i hope can you help me with that
Sep 04 2022 06:52 AM
For example, if cell A1 contains your date, you can use the following formula to calculate whether the day of the week is a working day.
=WEEKDAY(A1,2)<6
If you have other working days (not Mon-Fri), you must change the 2nd parameter. See here: