Last seen: Aug 30, 2025
Hello Joseph, If you are new to working with Excel tables then I can only recommend you to participate in this Excel Tables course. It gives you go...
Hello Joseph, Thanks for the data. For the ease of working with and maintaining the data I would suggest that you gather the time attendance dat...
Hello Paul, See attached file for two different solutions. For the Index/Match formula, you can read more information about the technique used i...
Hello, Your attachment seems to be without data. If you haven’t already, do check out this article, it contains good info.
Hello FS, The calculation you use in your sample file is (removing the IFs) =B2/A2-1 which is just another method to calculate and is correct. A...
Hello, I have tested too and can't replicate your error. A question though, instead of using the Full Screen command have you tried using the Auto-...
Hello, Not sure what you are looking for, as for when checking your sample file you get correct result with your current formula. Or have I misunde...
Hello, This article has a link to where you can download needed driver plus also some minor information.
Hello, Rule of thumb when calculating difference you should always subtract the lesser value from the greater. So it means you then need an IF stat...
Hello, You must divide with A2. =(B2-A2)/A2
Hello, In this article you have a similar lookup scenario as yours, have you tried this? If it is not working then it would be great if you can ...
Great that you got it to work! I can only say that the blog articles here at MOTH are just great, those and the courses I have taken here have help...
Hello, As this support page mentions, you probably need to enter the formula as an array formula. When checking this article for more info it seems...
Hello Alan, Check out this blog article for more tips and guidance. The formula you want is =TEXT([@[Extract Date]],”dddd”)
Hello, For Honeywell scanners I found this document, see pages E11 and E12. For Inateck I have not found any info that says anything about setti...