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

@Ramzner 

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:

https://support.office.com/en-us/article/60e44483-2ed1-439f-8bd0-e404c190949a?ns=XLWAENDUSER&version...