finish

  1. J

    Auto Colour Based on Time

    We currently use a sheet for daily resourcing. It captures start and finish times, and some of the management team like a visual Gantt chart view also. I was wondering if there any way of setting the sheet so it auto colours the cells based on the start and finish time entered...
  2. M

    Help with Check List

    I have a two part check list. Section and Area. I am using the formula =SUM(IF(FREQUENCY(MATCH(Table1[Section],Table1[Section],0),MATCH(Table1[Section],Table1[Section],0))>0,1)) to tell me how many different Sections there are. and =COUNTIFS(Table1[Area],"*") to tell me how many Areas there...
  3. G

    Highlight contractors without a finish time?

    I would like to highlight any contractors who do not have a finish time each day. I have a column for start time, finish time and one to calculate the hours worked. (3 adjacent colums going left to right) Ideally as soon as a start time is entered it would highlight the 3 cells for the employee...
  4. S

    Validations in Excel

    Hello Everyone, I have a task monitoring workbook and need to put some validations in place. Tried a lot with all the amount of Excel i know, but unable to get these validations working: All tasks much have estimated and actual start and finish dates. If a task is WIP, completion % has to be...
  5. P

    Help with a formula.

    Hi Guys I have the following formula: =IF(G2="","",IF(NETWORKDAYS(B2,B2,$AH$2:$AH$22)>0,MIN(18/24,H2)-MAX(6/24,G2),0)) References: B2 - Date G2 - Start Time H2 - Finish Time AH2:AH22 - Public Holiday Dates What this formula is meant to do is the following: 1- Look at the date to determine if...
  6. P

    Adding time across days

    Hi, I have a timekeeping spreadsheet that adds hours and minutes from start time to finish time. This works fine if you finish before midnight, but as soon as you go past midnight it counts backwards? Is there a way to ensure it always counts up? The formula looks like this...
  7. N

    Filling in the gaps

    i was wondering if some one could help me with the following problem and thanks in advance <colgroup><col width="72" span="17" style="width:54pt"> </colgroup><tbody> TIME 20:00 21:00 22:00 23:00 00:00 01:00 02:00 03:00 04:00 05:00 06:00 07:00 08:00...
  8. M

    How to calculate how many rows meet a time check criteria

    Hi All, I have a two columns of data in column b and c. Column B holds a start time and Column C holds a finish time. I need a formula in Cell E1 that can count the number of rows where a time that I insert in D1 is between the start time and finish times that are listed in Column B and C...
  9. N

    associate columns so they can be sorted together.

    Were going to have a race. Each person will run a course one at a time, with finishing time being recorded. After finishing time is recorded, the next person will run the course, and then their time will be recorded. Before race ever begins, column A will have names of contestants in the order...
  10. J

    How does VBA finish with ThisWorkbook.Close ?

    I am trying to finish some code by closing the workbook the VBA runs from. Is this possible? When I try to run the code with 1 workbook open, the code loops to PERSONAL.XLSB and gets stuck (code in there is specific to certain other workbooks). I'm aware that ThisWorkbok.Close closes the vba...
  11. H

    Help getting a blank space instead of a "0" form a formula

    =IF(C2>E2="","",IF(C2>E2,2,IF(OR(F2="S/O",H2="OT"),1,0))) is the formula I have and it comes out to be 0 in G2, I need it to be a blank space. For a formula using later. I am doing a NHL standings sheet. What formula am I missing to finish this.
  12. N

    Highlight a cell if it falls between 2 week numbers

    Hello, I am working on a file that a user will enter a start date and a finish date. I am trying to make the file decide which cells to shade based off its value. =IF($E4="","",IF(G$3>=$E4,-1,1)*IF(G$3<=$F4,1,-1)) and I have my conditional formatting set to change the value 1 to blue. It...
  13. O

    counting time

    I have a start time (BG13) and a finish time (BH13) which could contain any start and finish time (even start time today, finish time is tomorrow)..... is it possible to count how many 30 minute blocks are between (and including) those times? as example 5:30am start, 7:38 start (it is 2 hours I...
  14. J

    Conditional Formatting Question

    Given the Cell set in columns A to C, I want each of the first 5 rows to be shaded and the next 8 not to be (or shaded differently), and so on, alternating by date. <colgroup><col><col span="2"></colgroup><tbody> Date Start Finish 2/19/18 0730 0830 0830 0900 0900 0930 0930 1200...
  15. R

    Excel optimum sorting option

    Hi In simple terms I am trying to sort the below example by machine/previous operation finish date/recommended operation start day to give me an optimum start finish date for each work order/operation except on a much bigger scale. When I sort I get circular references because dates are...
  16. R

    User Form to show text box with last data entered in certain cell

    Hi thank you in advance for anyone helping with my problem. I have a user form with a combo box that lists truck 1, truck 2 etc up to truck 10 I have three text boxes with start hours, end hours and total hours which all works fine in the user form at updating my table but, What I cant work out...
  17. J

    VBA code for calculating time

    Hi I select a cell and press the button and it inserts date and time in cell I insert the start date and time in the ranges for F Column I then insert a finish date and time in the range for G Column I use this VBA code below with an Active X Control button Private Sub CommandButton1_Click()...
  18. T

    Determine Working Days between two dates and if it's valid

    I have a column for a start date (E2) and a finish date (F2). I also have a date at the top of every column that is the week starting on Monday (O1). I'm trying to write a formula to determine if the date in O1 is in between the start and finish dates and if it is, how many working days are...
  19. D

    Macro to Create new cell data from 2 sources

    Not sure if I can word this correctly but here goes.... I have a worksheet with hundreds of different "master codes" with descriptions and costs from one of our furniture suppliers. What i need is to create a worksheet with the master code having the finish code adding to the end i.e. master...
  20. A

    Summary Data

    Hi, This is a simplified version of what I am trying to do: ** Spreadsheet being amended ** You can see that this is a time recording spreadsheet for visits to clients. To summarise, on day 1 the technician visits a client, selects the client name from a dynamic drop down list, enter 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