start

  1. S

    Networkdays with start and end times on different days due to multi country shifts

    Hi, I am faced with this scenario where I need to calculate the number of minutes between two date & time stamps with the Start and End time in different hours . My scenario is as below Excluding Hours between 7:00 PM to 11:00 PM EST all other time, excluding Saturday and Sunday and...
  2. W

    Calculating time differences

    I have a Start Time and Stop Time column in my Excel spreadsheet that is feeding the Power BI reports. Time is entered in military time, however I cannot make Power BI Calculate the difference properly when the Start Time is one evening and the Stop Time is the following days morning (i.e...
  3. S

    Calculate start date

    Hi I am trying to calculate the start date of the first operation based on the start date of the second operation. Typically this is always going to be 7 days (5 work days) before. I can do this easily by just deducting 7 from the second operations start date however I have a calendar lookup...
  4. M

    Filter - Date interval

    Hello, My case is as following: I have a database of event participants with their respective participation period (start date and end date) as in below example: Name Start Date End Date Julie 11/03/2019 24/04/2019 Tom 25/03/2019 15/04/2019 Jeff...
  5. S

    Keeping the "0" as the start of a string of numbers

    Normally I use the "'" apostrophe to keep the "0" at the start of a string of numbers, but I am impurting the sheet into an excel tool which is dropping the ' and the subsequent "0". Is there another way to keep the "0" in the string. Thank you, Jerry
  6. L

    Reference from first and last values in a row

    <tbody> Start Date End Date Jan-20 Feb-20 Mar-20 Apr-20 May-20 Jun-20 Jul-20 A 212 518 623 B 891 218 563 500 C 926 777 </tbody> For the table above, I would like to return the dates corresponding to the first and last values in the row. For...
  7. V

    Formula or Code

    Hi All, Thanks in advance We have the following sheet Excel 2010 32 bit ABCDEF 1 2 3S.No.YearBatchSams 4193193000 5232193200 6378193000,3200,80008000 7424194000 8512192000 9693193000Sams 10768198000 11894194000 12924194000 131083193000 141135195000 151256196000...
  8. F

    Copy last cell before a empty cell and paste (same column)

    hi guys i need a macro or maybe if there is a way in excel, if i have a column like below and I'm trying to fill the blank spaces with whatever value is on the cell above. Not sure where to start on this. thanks for any help Colum A 1 --- macro should put a 1 1 2 2 2 --- macro should put a 2...
  9. M

    extract-all-rows-from-a-range-that-meet-criteria-in-one-column-in-excel using vba

    Hi I have found an array formula that allows me to select a list of details from a master list in excel based on 2 criteria and referencing a specif column. This array is very slow and time consuming. I have tried googling for something similar using vba but could not find anything similar. I...
  10. S

    Partial Weeks

    I am trying to create a formula or script that will identify partial weeks. The end goal will be to yield if a month ends in the middle of the week I want to have the week start date be the same and the end of week be the last day of the month and the start of the next month be the first day of...
  11. L

    calculating progress of Time or Date

    Hi I want to calculate the progress. I have Start and End date and also Start and End time. I want to find the progress as of today and time now. So I used conditional formatting --> new --> based on cell value -->bar (please see attached excel file). for date A2= Start date: 1/1/2019 C2= End...
  12. R

    quarterly calcs from month numbers

    I've been asked to calculate quarterly dollar spread based on start and end months. I need it in this format. removed bad image Q1 calc is easy, but gets complicated (for me) on the rest. Any help would be greatful. Thank you. <tbody> start month end month total cost q1 q2 q3 q4 3 7...
  13. W

    Custom Data Validation

    Hello all, I am trying (and failing) to implement a custom data validation to prevent issues during data entry. I need to permit the following example formats: 4.1 4.2.1 4.3.1.1 I can get the '4.1' level working easily enough (as it's seen as a number with decimal), however once I start...
  14. K

    Change shape size (Rectangle) based on two cell values (Start Date) & (End Date) Excel 2013

    Hi Excel Guru's, Im trying to create a scheduler where in a shape (rectangle) will be based on two cells (Start Date) and (End Date). Both shapes and date values are on the same sheet. Can you help me? Advance thanks to you all.
  15. L

    # of months or year between start and end dates

    Hi I know how to find number of days between start and end dates by simply subtracting end-start. I also know how to find how many working days between start and end date using networkdays() function. My question, how can I find # of months between a start and end dates? and also can I find how...
  16. W

    Copy target value across based on cell value

    Good Evening All, I don't know if this is possible and am really struggling with this problem. We have a sheet which lists how many actions are needed to be done and what week they will start closing them out followed by how many weeks it will take them. This way we can give them a target...
  17. gheyman

    Select data (Row) in one table and have it load/add to abother table

    I have data in an ODBC table. What I need to do is when someone selects a record in that table, have it automatically load data from that record to another table. Not sure where to even start or what to research. Any advice/direction is appreciated
  18. Heber

    time calculation on working hours less weekend

    Hi I am Struggling to solve this! I need to calculate time between two dates, but need to be only between 8:00 AM and 5:00 PM, excluding weekends. I got some results, but when the start time is over 5:00 pm still add the time... example below: Start End Transmission time (h:mm) 28/09/2019...
  19. G

    Horizontal Bar Chart Question

    Hello All, I thought this may be easy, but I'm finding it aggravating <tbody> Project Name Start Finish Project 1 11/16/19 3/15/20 Project 2 6/12/2019 1/14/2020 </tbody> I want to make a horizontal bar chart with a series name of the projects...
  20. C

    Univers and Channels for pixels

    Hi, I am wanting to put together a spreadsheet that will calculate my pixel led lights into universes. Each Universe has 510 channels, each Universe increments by 1, you can hundreds of universes. Headings will be Channels used (A), start universe # (B), start channel # (C), end universe #...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top