right i need some help with this. I have to work out a pro rata for people based on the amount of days they have worked over a quarter period.
I have a start date for them and an end date for them. first off i want to work out how many active days they have worked over the quarter. so from...
Dim RowNumber as long
RowNumber= Columns("B").find(what:=cboJump,,xlValues,, xlRows,,,False).Row
The code is in Worksheet cboJump_KeyDown event.
I'm sure this worked yesterday
I also tried Dim Rownumber as Range and "Set RowNumber = ..." but same error.
Hi,
i need a calculation in J2 formula which looks at the age of the employee in Column B and compare it with the Age of column F .when it finds matches in age then it Calculate in this way G2*C2 (8.31*2) and H2*D2(10.39*8) and I2*E2(11.22*2) in this case
thanks
<tbody>
A
Employee
B
Age
C...
I tried recording a macro and at first it worked then I got trouble with it. I found this macro on the internet and it worked at first, but when I tried to run it today I got the debug box to pop up. Can anybody tell me what is wrong with it and offer any suggestions so that it would work...
Good evening Everyone!!
I am confident that someone in this forum will be able to assist me with my dilemma. I am the payroll processor at a Golf Club management Company where we host several event functions in different venues on property. There will be times that we have 2 or 3 functions...
Hi,
I'm putting together a timesheet for my company and I'm having a bit of trouble doing hour totaling. On the same sheet I have rows for different job numbers and columns for days of the week. I also have 2 sections on one sheet, one relating to regular time worked and one relating to hours...
Hi All
Im trying look at a start and end time and trying give 5 mins for every completed hour worked
ie if someone worked 02:55 hours then that should return 10 mins as there are only 2 completed full hours but struggling with this formula
Also trying to get a multiple or sumifs to total up...
Hi,
Can someone please help me with this formula?
I have this info:
Column A = employee name
Column B = hiring day
Column C = vacation start date
**Column D = Xtra vacation days
Column E = Value from column D + 15 (default)
**If an employee has worked more than 4 years, put in...
Ok ... for some time I have had a puzzling issue with an Excel macro enabled workbook that contains a single SQL query to another database. I cannot stress more that for YEARS it worked with no problems at all. Then one day it just does not work anymore .... the code runs but it does not...
I am trying to figure out how to apply a toggle box that enables a macro to run on the current row it is selected on.
I have an example spreadsheet that has 2 worksheets. The first Worksheet for the current Jaunary 2018, and the second worksheet is for the January 2017.
The column A1 is labled...
I have a Vlookup:
=IFNA(VLOOKUP($A4,'ON 2019'!$A:$H,COLUMN(),0),VLOOKUP($A4,'ON 2018'!$A:$H,COLUMN(),0))
Is it possible to then have this formula working after the Vlookup has worked out:
=LEFT(B4,8)&" "&MID(B4,9,6)
Thanks for any help
I have a column of dates (N) in date format (MM/DD/YYY), another column that counts total years worked (M), and a column with starting date (D) also in (MM/DD/YYY) format.
I'm trying to get it so that when today's date is equal to or beyond the date in column N, the years worked (M) gets...
Hi there,
I'm having trouble figuring out how to add up information from one sheet onto another separate sheet.
For instance, I've got multiple entries on the first sheet for a guy named Sam who worked 4 hours on seven different days. I have a second sheet where I want the computer to find...
Hello I could really use some help completing this formula. I recently realized my worksheet has not been adding double time hrs. correctly. In California DT is pay on two occasions
For all hours worked in excess of 12 hours in a workday.
And for all hours worked over eight(8) on the seventh...
Hello: I am trying to write a formula to calculate per diem based on the number of days that someone worked AND add an additional day if the person worked 5 or 6 days. Right now I have the following to just count the number of days they have worked:
=COUNTIF(R14:X14,"<>0>)
This returns the...
Hello!
I am really new on the VBA world. I worked with several macros from websistes and in some point they do not worked OK.
I have a file with multiple columns. I want to filter by a particularly column (filter by last name) and the selection I want to save it using the as file name the...
I am stuck and cannot figure out a way to get a msgbox to pop up at a specific set time only when a specific worksheet is active. I have found a few ways that work, except they just worked when the workbook is open no matter what sheet is active. Please help, thank you.
Hi Everyone,
I am using power query to access a file from share point. I used Microsoft flow to connect an email folder to outlook (get attachment). This folder will receive an attachment everyday. So far only two days this flow has worked. Here is the error that I am getting. "External table...
Hi,
I'm trying to install an "IF" statement on a simple spreadsheet where the employee puts in a simple "Y" or "N" if an associate worked a particular day (Monday to Sunday 2 week period therefore 15 days). I currently have this for one day =IF(C4="Y",1,0) but would like to encompass all 15...
Hello all,
As ever, i wondering if anyone can help with a problem i am having.
In columns B & C of the attached i have some times and dates where we asked colleagues to work at short notice. In columns E & F is the time colleagues actually worked.
I would like to take each instance of when...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.