Forum Discussion
Please i need help !!
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
1 Reply
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)<6If you have other working days (not Mon-Fri), you must change the 2nd parameter. See here:
