worked

  1. J

    Date Fields

    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...
  2. A

    was ok - suddenly get error 91

    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.
  3. B

    Calculate Based on Different Values in Multiple Cells

    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...
  4. T

    Text to Columns Macro

    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...
  5. C

    Service Charges for Restuarant Employees

    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...
  6. H

    Hour Tracking with Multiple Overtime Tiers and Shift Premiums

    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...
  7. S

    Add 5 mins depending on hours worked

    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...
  8. E

    Conditional formula

    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...
  9. M

    VBA Code to refresh data no longer works

    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...
  10. M

    Select a Checkbox to enable a macro on the same row

    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...
  11. H

    Using a Left and Mid formula with a Vlookup

    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
  12. E

    Highlight Cell When Value Changes, Reset On Re-Open

    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...
  13. B

    Relaying data from one sheet to another

    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...
  14. A

    Calculating double time after 8hrs

    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...
  15. J

    Conditional Formula, I think?

    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...
  16. C

    VBA. Split one file into multiple ones based on a filtered column

    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...
  17. J

    Msg box displayed at a specific time only when a specific worksheet is active

    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.
  18. D

    External table is not in expected format

    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...
  19. A

    IF statement for simple hours calculation spreadsheet

    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...
  20. L

    Overlapping Times and Date

    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've detected that you are using an adblocker.

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.
Go back
Back
Top