Search results

Good morning Lutfor. Thank you for your assistance to my query. It seems that this could be a complex exercise if you have to apply this formula to about 100 employees every month. If there is no simpler formula to use, then I will have to calculate the holidays manually. Thanks once again for...

Further to the above, sometimes the employees do work for less than 7 hours after 00.00. Like instead of knocking off at 07.00 the employees not off at 06.00 or 07.30. How can we accommodate those variations?

Thank you for your quick response. Your formula works fine but it misses the minutes when the employee's holiday has minutes outside the hours worked. Like employees who reported for duty on 3 August in the evening shift had to be paid holiday hours from 00.00 to 07.15 on the 4th which is =...

Good day. I have a table that adds total hours worked by employees. I however wish to have a formula that will tell me the number of hours worked on holidays. I have a list of holidays for the year and I wish to create a formula that count the number of hours in one particular month e.g. August...

Yes please. Thank you once again Lutfor.

Thanks once again Lutfor. It seems what I was asking was a bit complicated and not quite possible. But thanks for trying so hard to help me.

Good morning. Thanks once again Lutfor for your response. I see you have given a formula that summarises the total gas issued per vehicle. I actual want the issues itemised on the summary page excluding cells where no gas has been issued in the sourcedata page. 1. The first issue being cell...

Thanks Lutfor for your response. However, what I am trying to do is to have the summary page pick the information from the sourcedata sheet where there are there gas issues and omit the the lines where there are no issues at all without changing the layout like I have done on the summary sheet...

Good day. I have a spreadsheet where I post gas issued to company vehicles. The vehicles do not put in gas everyday. There are days when no gas is issued. I have a sheet on spreadsheet which I call Sourcedata when I do the postings. I have created another sheet called Summary where I want to...

Good evening. Thanks so much for your assistance. The formula works correctly and you have been of great help and keep up the spirit of helping others.

Thank you so much for your response and the formula works fine. In another scenario where the earnings are over a period of 9 months, the earnings and the rebates are annualised to enable proper calculation of tax. The resultant tax on the annualised aearnings are then divided by 12 and...

Thank you for the reply. It's much appreciated. From the formula that you have given, it does not give the same result compared to the one calculated manually. CASE 1 From the taxable earnings on B6 the tax should be, in the case of someone below the age of 60= B17 and in the case of someone...

Good day. Trusting you are well. Can you please help me with a formula that will calculate tax from the attached table. The expected tax deduction is on line 24 of the spreadsheet. However, the formula is supposed to be linked on the table below the example. The rebate should be dependant on...

Thank you once again. I'm giving you 100% thumps up.

Thanks once again. It seems when you delete the value in A33 or put a zero the result on G33 gives a ZERO instead of a BLANK. Can you please recheck for me.

The last question that I have is if cell A is blank or has a Zero, how do you make the result Blank instead of a Zero?

Thank you so much. It's working perfectly.

Thank you so much. Can you please help me by applying the formula on my spreadsheet to see if it gives the required results on G33 to G35 which has to be the same result on F33 to F35.

Good day. Good morning. Someone helped me with this formula =IF(A20=0,"",LOOKUP(A20-0.01,$A$4:$A$13,$D$4:$D$13)*(A20-LOOKUP(A20-0.01,$A$4:$A$13,$C$4:$C$13))+MIN(A20,LOOKUP(A20-0.01,$A$4:$A$13,$C$4:$C$13))) to create a deducton table for shortages as per the attached file and it works perfectly...