Please i need help !!

Occasional Visitor

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.


 If you have other working days (not Mon-Fri), you must change the 2nd parameter. See here: