1. B

    Concatenate Records from Record Set (rs) SQL Query from ACCESS Database

    Hi Cummunity, Needing some help to concatenate row values being retrieved from ACCESS Database. INstead of writing to multiple rows, i need to concatenate all the record set values and write it to a single cell. Here is a view of part of my code: Currently there are two rows in the database...
  2. S

    Vacation Time Formula

    First off, I apologize if this question has already been asked and answered! I am looking for a formula to determine employee vacation time. Our VT is distributed in hours not days, and no hours can be carried over to the next calendar year. My spreadsheet already has employment start dates...
  3. T

    Number of Staff during each 30 minute interval

    Hello Team.. another request.. Been thru similar requests threads..none matched my requirement. Based on the below RAW DATA, I want to know how many staff I have at any given time. SAMPLE RAW DATA: <colgroup><col><col><col><col span="7"></colgroup><tbody> EMP ID Emp Name Supervisor 14-Oct-18...
  4. J

    Formula For Counting Vacation Days

    I have a vacation calendar to create for 2020 and I use NETWORKDAYS to give me number of days that a person needs for vacation. For example, NETWORKDAYS formula applied to a vacation from 9/2-9/6/19 yields 5, which is correct. My problem is that some employees work on the weekends, so applying...
  5. G

    How to set up formula in excel

    Hello All, If anyone can you assist I would be greatly appreciate it. Ex.: I have a list of 10 Employees that do various jobs. Of those 10 employees, 3 employees cover the job of the person(s) on Vacation. The maximum number employees on vacations is 3. I would like to show (in a excel...
  6. N

    Help with Vacation Spreadsheet

    I have a main worksheet that draws info from another worksheet called vacation. Vacation has the amount of vacation time in hours the employees get each year and also vacation carried over from previous year. Main worksheet has 31 employees and their attendance for each month in 12 tabs (each...
  7. E

    Date conditional

    Hi, Can someone please help me with this formula? I have this info: Column A = employee name Column B = hiring day Column C = Original vacation days per year (15 or 20) **Column D = Xtra vacation days Column E = Total vacation days (15+column D) For every year worked after 4 years...
  8. E

    How to replace a pivot table by formulas?

    Hi, Can someone please help me with this? Every month I have a raw data report with these columns: Employee, Leave type (vacation, statutory holyday, other paid leave), number of hours, week, day,month. Instead of doing a pivot table, I would like to organize the information with formulas...
  9. E

    Vacation Accrual Formula Help!

    Hello! I have been assigned to making a vacation accrual spreadsheet that will auto calculate vacation time for the coming year based on hire date. The parameters are complicated and I am stuck on how to do this. 6 months after their hire date they start accruing vacation at a rate of 3.07...
  10. S

    calculating vaction accrual by hire date

    i need some help fixing a spreadsheet to helps to calculate vacation accrual
  11. S

    calculating vaction accrual by hire date

    I have been asked to calculate vacation accrual for the end of the year. vacation is earned at the hire date. I was trying to calculate how much is earned monthly.
  12. M

    Macro to flatten the data table

    Hello all, I am looking to see if someone will help me create a macro that would flatten a data table (or move the data from rows into columns) by Name and Activity in excel. Basically I need to go from this (but there will be many different activities per name): Name - Activity - Start...
  13. juleska


    I've got two sheets in my workbook. One is a list of all employees on a project, the other is a list of employees currently leave. I need a function that looks in the "Employee ID" column of the employees on vacation, and if matched, returns a value in another column indicating their status...
  14. M

    Convert Vacation Hours into Days/Minutes

    Does Excel have a function to convert hours off into days (8 hour day) and minutes? For example If I have 51 hours of vacation If I divide that by 8, that equals 6.38 days off So I have 6 days off + .38 of a day. How would .38 equate to hours/minutes?
  15. B

    Vacation Accrual Can anyone assist with the following vacation accrual attached is a dropbox link for what I have so far. I need to populate the accrued vacation based on the accrual date which we get 10 hrs a month or 120 a year. I need it to stop...
  16. Nuclearman83

    Count Number of Employees Absent Within Dates

    I am trying to determine the number of people (List of Employees) on vacation based on their vacation start date and end date (Employee Leave Tracker). I need to account for each day of the year and ensure a certian percentage is not absent. I have tried: =COUNTIFS('Employee Leave...
  17. C

    Fill Employee name to specific cells if status is "Vacation Leave"

    Hi All, I need some guidance and ideas on how to Fill each Employee names if their status is "Vacation Leave" to the corresponding date of the calendar sheets. For example on the image below, In row 3, Robert Downey Jr. and Chris Evans should be filled to January sheet (cell G8 and G9) in...
  18. M

    Accrual VS. Usage Formula

    Ive got a nice spreadsheet set up with all the info I need, but I cant get the formulas to tie together correctly to calculate properly. Im getting very frustrated! Please help. :confused: Why cant we attach excel here?!?! <colgroup><col><col><col><col><col span="3"><col span="3"><col><col...
  19. M

    Vacation accrual formula HELP!

    Hey guys! Im new here and am getting really frustrated trying to make my formula work. I need to accrue vacation time for my full time employees. At hire date anniversary, they get 40hrs and accrue 3.33hrs per pay period. I need to figure out the formula for my balance column at the end, AF6...
  20. M

    Trying to do a date range IF statement

    Hi everyone, I'm stuck on what looks like a pretty simple formula. What I am trying to do is, I have a work schedule for a production team on one tab. I also have a vacation listing on a second tab. I am trying to write a statement that will say to look at the employee's name (A6), look at...

Some videos you may like

This Week's Hot Topics

  • SUMPRODUCT active link formula
    Hi guys i have sumproduct formula for counting two range of number, i want count active cells of formula that linked to another sheet...
  • Block certain cells in condition met in cell A
    Hi there, trying to figure out step by step how to build macros and learn more. Now given that my other code was a mess, I figured I would...
    Hi, Below formula works well, =(INDEX('PRICE LIST'!$C$7368:$C$7679,MATCH(1,(WORKSHEET!O28='PRICE LIST'!$A$7368:$A$7679)*(WORKSHEET!P28='PRICE...
  • Match data from 3 columns to return data from the correct 4th column
    Hi there! I'm trying to have a cell auto-populate the data in a cell based on the data entered in 3 other cells. I've pasted a copy of the...
  • VLookup
    Hi everyone, I need to find the value from one sheet to another. So in Sheet A Field N5 I have a value (Spark) I want to find Spark on the Sheet...
  • Defining a range
    Private Sub Worksheet_Calculate() Dim Xrg As Range Set Xrg = Range("K1") If Not Intersect(Xrg, Range("K1")) Is Nothing Then MsgBox...

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