start

  1. S

    VLOOKUP in a Range of Dates?

    I don't even know if a macro can help me with this. I have a listing of employees showing their annual pay rates by a range of dates. I need to be able to look up a date within those ranges. For example: Employee # Start Date End Date Annual Salary Employee 123...
  2. P

    Subtracting two time inputs on a spreadsheet and performing a mathematical equation

    In Cell A1 I have text Start Time and Cell A2 I have text Now. Cell B1 contains the start time (manually entered) and cell B2 contains the NOW() function. Cell B3 subtracts the difference between cells B2-B1. All that works as expected. Now the issue, I need to take the difference convert it to...
  3. B

    Formula to allocate value by date per day...

    Hello, I hope someone can help. I have a start date and end date with a value associated those dates. I want to create a monthly view showing the value if a date is between the start and stop date. cell B3 contains the "Start date" 10/2/18, cell C3 contains the "End Date" 10/5/18, and cell...
  4. C

    Network Days Between Dates

    I am trying to calculate network days between dates in PQ. I created a customer calendar parameter and removed weekends and holidays from the tables. I then created an index column starting from 1 that numbers my days with the idea that I would look up the end date number then the start date...
  5. S

    Counting how often a time appears

    Hi, I am hoping someone out there will be able to point me in the right direction as I have been searching for ages and can not seem to get anything to work that is not really long winded. A B C D E <tbody>...
  6. N

    Need help creating an aging measure

    Hello All! For starters, I am very new to Power BI so please go easy on me. I'm trying to create an aging measure to be used in a visual that will count the total number of claims pending over 31 days at the start of each month. This will be used as a historical visual so most of the figures...
  7. K

    How to open a file using inputbox to type file name

    Hello! I am quite new to VBA, but I am trying to create a program that allows me to push a button that asks for a file name, and after entering the file name, it opens up the file I requested. I have attempted this here, ______________________________________ Sub Start() Filename =...
  8. S

    Start date end date calulation

    Hey guys hoping someone can help me with this. I can play around with dates use helper cells etc. I have various start dates, end dates and then a PO Amt for each project. I need to straight line all amounts over the time frame. I currently have 2016/2017 in years and then 2018 by month. I...
  9. M

    VBA code to set autofilter based on start date and end date in seperate cells of the worksheet.

    I have a table with 23k rows of data and there is a column with dates from 2004 to current date. Each month I need to filter and copy the current month rows into a new worksheet. I want the macro to filter a start date in cell K1 and end date in cell K2. I cannot the after/greater than K1 and...
  10. P

    Data Validation

    hi all, busy trying to work out some data validation on my time sheet, to stop erroneous entry's. column A is travel time start column B is job start time column C is job stop time. I need to check that the start time is the same as the previous stop time, eg job 1 travel 0800 start 0820 stop...
  11. H

    converting text to date/time

    Good day all, I am not great with date/time things in excel. I have one column that is a text column that gives time intervals in seconds. I have a separate cell that gives a start time/date. What I want to do is create another column that adds the seconds to the initial start time/date, so...
  12. J

    Calculating values by date range

    Hi all I have a spreadsheet where I have a sales forecast by both annual and quarterly breakdowns. Where I have a start date quoted, unless it is at the start of the quarter, I don't get an accurate figure in the Q1/2/3/4 columns. Example - Correct result (manually obtained) Part A - Agreed...
  13. J

    Formula for deciding shift differential based on a start time

    Hi i'm trying to figure out how to write a formula that would look at a shift start time and based on that time would output the correct shift premium to the cell. So I have 3 scenarios a start time from 05:00 to 13:59 no premium. 14:00 to 21:59 .75 cents per hour and lastly 22:00 to 04:59...
  14. J

    Date and time

    Hello, Hopefully soon can help me. I am trying to work out how to create a formula to make a plan showing when a total process will be finished and also each stage start and finish times. The time for each stage is fixed, but the initial start time may vary and the process in total will span 3...
  15. S

    Utilization of room by hours of the day

    All, I have a data of start time and end time that represent and engine start and stop date/time. I have 10 engines. they could run for minutes, hours, >24 hours, days etc. I would like to sum the time running for all hours of the day 0-24hr. A bar chart that sums the amount of hours for each...
  16. A

    Return A cumulative Percentage value based on Today's date referencing a start and end dat

    Hey everyone, I have been stuck for a while trying to figure this out. This is what i have: Start Date End Date Days Weight Status Planned Value Actual Value 1-Feb-2018 5-Feb-2018 5 10% Red/Green/Yellow ( Function 1 ) Function 1 = =IF(AND(Today()>=Start Date,Today()<=End...
  17. P

    Time

    Good morning all I use a spreadsheet to do my shift updates at work but I am finding the other shifts are entering false hours to make things look good. So what I would like to do is pull the hours from the start time and finish times the issue I am having is some production runs finish a...
  18. sharky12345

    Fill down column until next non-blank row then start again

    I have some cells with data in column M between M7:M100 - only cells M7, M16, M26, M35 and M42 have values. I need a VBA routine that will start at M7 and fill M6:M15 with the same value, then start again from M16 and so on. Can anyone start me off please?
  19. B

    Chart Axis labelling - selecting which point the numbering starts

    I had a time coming up with a concise title... but hopefully this will explain it better. I have a line chart with values on the vertical and yearly quarters along the horizontal. The yearly quarters are labelled 0.25, 0.5, 0.75, 1.0, 1.25... etc. As there area lot of quarters I have the...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top