crew

  1. 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"...
  2. A

    Pulling several numbers from a data sheet into another sheet by date/crew/charge type

    I want to fill in a spreadsheet (Sheet A), based on another sheet with data (Sheet B). However, I need it to look for several items at a time on Sheet B and consolidate the totals before entering into sheet A. So, on Sheet B, I have a bunch of data - Carrier, Date, Crew, and a breakdown of...
  3. I

    Formula needed

    I run a report that I export into excel and it will have multiple names in one column separated by a comma. How can I move the crew members into their own column? <colgroup><col><col span="3"></colgroup><tbody> Current COLUMN A...
  4. T

    Complicated multiple looksups using two separate worksheets

    I really have no idea where to start here. I have two worksheets and I need to match a Crew IDs in one with the Crew IDs in another. Note, there are multiple rows with Crew IDs in both. For example, There are probably 100 crew IDs in both and multiple rows of each Crew ID in both. I want to...
  5. M

    Identifying work crew on shift by timestamp provided in productivity report.

    I receive a report which details the time a truckload of material was dumped as a timestamp. I am wanting to write a formula which interrogates the timestamp and can then identify which work crew was on shift at the time the load was dumped. Shift details are as follows: 4 crews: A, B, C, D...
  6. M

    Use timestamp to identify work crew. 4 crews working week on, week off and rotating day and night.

    I receive a report which details the time a truckload of material was dumped as a timestamp. I am wanting to write a formula which interrogates the timestamp and can then identify which work crew was on shift at the time the load was dumped. Shift details are as follows: 4 crews: A, B, C, D...
  7. N

    Countifs using criteria with a date time

    Looking to do a count ifs fomula for below data Count of Culomn G:G Criteria column B (Has a date time 24hr) is greater than or = 1/8/17 08:00 and Date less than or =1/8/2017 20:00 and Column D = "C" So I get a count for each day and shift of (Column G) i.e for 1/8/2017 Day Shift the count...
  8. A

    Need macro help sign in sheets

    I need sign in sheets to populate based off of a master list. I need them to populate based off of what crew they are assigned to. For example I need a sign in sheet for all of the people on John Doe's crew to be on one sign in sheet and Jane Doe's crew to be on one sign in sheet etc. When...
  9. K

    Userform checkbox submission

    Hello, I am brand new to VBA and would really appreciate any help anybody can offer with my userform. I am using excel 2016. I am trying to make a userform to record a daily log of crew on board a number of different boats. I have date input via textbox Boat selection is via three different...
  10. C

    How do you check for value "<Path not found>"

    I have some VBA code that exports the source code to a file. The following statement is giving me a problem: if len(vbproj.Collection(i).fileName)>0 then 'Do something end if Unfortunately, looking at the vbproj object I find that vbproj.FileName shows in the watch box as Path not found ...
  11. T

    struggling with Match and Index

    I need help Im trying to look up crew number based on Day number and Time sheet 1 has in A1 the Day number of the year A2 has the hour I want the formula in A3 to find Day number and Hour number in sheet 2 and return crew number sheet 2 has a database A1 is day number, A2 has Hour, A3 has...
  12. C

    Matching a time stamp to a shift and identifying the crew....

    So, I have two spreadsheets. One has a list of data with a time and date stamp on it. The other has the crew shift schedule on it. Spreadsheet 1 A B C D 1/1/11 8:00 PM 42 637 11222 1/1/11 11:00 PM 66 499 10978 1/3/11 5:00 AM 27 529 10223 1/3/11 7:00 AM...
  13. M

    Vlookup in reverse/Crew assembly

    Hello, I have a huge spread sheet of different crews for my estimating program which i have attached a sample of it, i want to be able to put the number of the crew members in the exact kind of form with blank quantities, and the name of the crew pops up, i want to say: i need 1 forman,3...

Some videos you may like

This Week's Hot Topics

Top