1. FuNeS13

    get time between two rows, rows are not continuous.

    I have a spreadsheet that logs the start and finish of a task... I want to get the total time between the start and finish row, the thing is that the rows are not continuous, column A/B and F would be my triggers I guess as column A/B are the employee ID and Column F is the "Start/Finish"...
  2. K

    Times Numbered

    Hello! I am looking for a formula that lists a new number ever time a new time would appear. For example (7:16, 7:16, 8:34, 9:25 = 1,1,2,3) the only problem is, i need this to start over every time a new day appears in another column. i hope that's clear and that someone can help.
  3. B

    Automatically start a function

    I have a code that hides the ribbons on top of my excel sheet and the code looks like this. Private Sub Workbook_Activate() Application.ScreenUpdating = False Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)" Application.DisplayFormulaBar = False Application.DisplayStatusBar = Not...
  4. leopardhawk

    Need help with complicated IF statement, possible IFS?

    I have a worksheet that will most likely be used by two people (a couple) but could also be used by a 'single' (unmarried) individual. I'll try to explain my conundrum. Here goes... The worksheet contains a cell with the following formula and it works as intended but I would like to modify it...
  5. TAPS_MikeDion

    Finding Difference Between Two Times

    Hello, I have been trying without any luck to find the time difference (Sun - Sat, employee start & finish times) between two columns of times, but the finish time may go into the next day. I found a post here that I thought might work, but VBA MOD is apparently different from Excel MOD. I...
  6. A

    Adding time to date & time but fit within working days & hours

    I'm trying to do a calculation where time can be added but only adds within working hours & days. I found this calculation...
  7. T

    Skip columns from a cell

    Hello, I am trying to jump columns in excel from a cell, could anyone help? I'm trying through For sub test () For i = 1 To 5 Cells (i) .Select Next i End Sub What I need is to start in cell A, then jump every 10 columns until it's over.
  8. willow1985

    Multiple IF AND statements including LEFT

    Hello, Quick question. I am looking to do a multiple IF AND statement including LEFT. The below formula gives me a #VALUE error so I know I am doing it incorrectly: =IF(AND(C2="Blue",(LEFT(D2,1)="C"),"250",""),IF(AND(C2="Blue",LEFT(D2,1)="B"),250,"")) C2 has to be Blue AND D2 has to start...
  9. TAPS_MikeDion

    Listbox w/Day of the Week & Start/Finish Times Column Headers, and HH:MM format

    Hey guys, My assumption is that there has to be a better way. In my ListBox, I'm trying to get 3 column headers (DAY | START | FINISH) and also have the time displayed in the list as 10:00AM, as opposed to being a decimal (0.41666666), which is why I was trying "* 24" in the code. If anybody...
  10. B

    Auto-fill column when inserting a new row?

    I've got a spreadsheet with a hidden 'start date' column. The start date is going to be the same for all tasks that are inserted into the sheet, so I want it to automatically fill this date in when people insert a new row. Is this possible??
  11. A

    complex date count formula help

    i can't seem to get my head around this formula. i have a range of project data where each record has start, end, and change dates. Some of these records begin prior to the start of the financial year and some start within the financial year and then end after the end of the fin year. The change...
  12. S

    Another Time comparison problem

    So I have thousands of rows of data every day. In column F I have an event code and in column G I have the duration of that event. I need to know if "Event B" occurs within 20 minutes of "Event A". If F2 is "Event A" and G2 is 0:09:23 and F3 is "Event X" and G3 is 0:00:03 and F4 is "Event Y"...
  13. R

    Updating a value using match

    Column X contains a list of all companies. Column Y is used for a simple check (values would be yes, no, n/a) In column Z I have a partial list of company names. Here is what I need help with: I need to start at Cell z2 see if that value matches ANY value in my column X Range (x1:x1000) If yes...
  14. I

    +1 Stop Counting and Start Back to 1

    <tbody> a b c d e 1 1 2 =B1+1 3 =B2+1 4 =B3+1 5 =B4+1 6 7 8 9 </tbody> Hello All! I was wondering if someone could help me with a formula to cycle back to the number 1 after it reaches a limit of 83. I was using the formula above, but when it...
  15. S

    Sorting spreadsheet by time

    Hi I have a spreadsheet that contains among other columns, 2 columns. They are start time and end time. Their format is 7/1/2019 2:17:11 AM for example. Of all the start times, I want to ONLY retain the information where the start time is */*/2019 21:00:00 PM and the end time is */*/2019...
  16. P

    SUMIFS with array that counts number of valid days within a date range

    Hi there, I've tried to recreate two tables which I'm working with below: <tbody> Start Date Finish Date Effective Days Total Amount Daily Amount Month Start of Month End of Month Monthly Amount 04/09/2019 22/10/2019 49 1000 20.41 Sep-19 01/09/2019 30/09/2019 ??? 15/09/2019 15/10/2019...
  17. B

    Excel time formulas

    Hi, I'm looking for a simple formula that will calculate the difference between a start and an end time then subtract 30 min. So, for example, the start time is 7:00 am and the end time is 4:00pm. I can calculate the time difference but I don't know how to then modify the formula to subtract...
  18. A

    Working Comparisions With Midnight

    I have an activity start time variable, lrtime equaling 0.7708333333 (7:00 PM) I need to compare it to ensure that lrtime falls within the employee's shift. ie lrtime <= sel_crew1_end. The value for sel_crew1_end = 0 (midnight) sel_crew1_end = WorksheetFunction.VLookup(Me.cb_r1_crew & "1"...
  19. T

    Formulas rto split start and end dates into 24 even dates

    Hi Everyone, I'm trying to create a chart that show a timeline and need to divide a start and end date up into 24 even dates The Start date is in Cell L11 End date in M14 Can this be done? what happens if the two dates are less than 24 days apart? please help thanks Tony
  20. T

    Excel Validation Help Please

    Hi - I have an excel sheet that has 3 fields:- C2 - Trip Limit C3 - Trip Start Date - dd/mm/yyyy C4 - Trip End Date - dd/mm/yyyy If a user enters a Trip Limit of 20 in C2 and if the End Date in C3 minus the Start Date in C4 is more than 20, I would like an error message to either warn 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...