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 + Ove...
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: