crew

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"...

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...

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...

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...

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...

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...

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...

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...

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...

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 ...

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...

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...

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...