scheduled

<tbody> UNIT ATTENDANCE 1 2 3 4 5 UNIT 1 2 3 4 5 28CSH SCHEDULED 8 12 12 8 12 28CSH ACTUAL PRES PRES FTR LV PRES 601 ASMC 28CSH SCHEDLED 12 12 12 8 8 ACTUAL PRES PRES PRES FTR LV 601 ASMC SCHEDULED 12 8 8...

Here is what I'm trying to do. A meeting or documentation turn-in needs to be scheduled for a certain date & be held, otherwise the cell where the date goes turns red and bold yellow font. I use an internal calendar with key dates being referenced including today's date, the date of the...

Can I Vlookup a date+time if I only have the time? For example, I have the Scheduled Time only in Table B. I want to Vlookup the Date+Time from Table A. <tbody> Table A: Reference Table Table B: Final Table Scheduled Date+Time Actual+Time Scheduled Time Actual Date+Time (VLOOKUP)...

Hello again everyone...back to be a pain...... I am trying to figure out a formula to get the next scheduled date from a row. I have my entire months schedule in an excel sheet, with "Rest Days" and "Vacation Days" mixed in with start times. https://1drv.ms/x/s!Amk_7FQHP36kg-QJndYbzMT0UBfUaw...

Hi guys, I am really struggling to use PowerBI in the following setup: I have a PowerBI desktop. I Created a project where I import data from an excel file on my PC and I installed personal gateway and setup a scheduled refresh, so it will be published online also. I get to endless problems...

Hello, In column A I have the scheduled date for a task to be done. In column B I input the real date of task when it is done. In Column C I want to reference the real date if entered, or if real date is blank reference the scheduled date. Can someone suggest a formula please? Thank you!

Hi I was assigned a project at my work to represent a visual graph on appointment duration. I schedule appointments for my doctor and our boss wants to see if hes completing the scheduled appointments on time. I was thinking of using a visual chart that would compare his actual scheduled...

Hello, Is it possible to work with gaps.There must be a gap of 8 days between visits throughout the year.Can I do this automatically?Location X must be scheduled every 8 days for a visit, starting on 2 JanuaryI do not succeed with macrosWho can help me dave

I need a WB to auto_close after Scheduled Tasks opens it but stay open when a user opens it manually. Is there a way to determine via VBA when a WB was opened by tasks (or, looking at the problem from another angle, not opened by a user)?

Hello, Currently I'm copying group data range by JOB ID from Sheet1 to Sheet2. So table for example please see below: Grouping JOB IDs then sending them to Sheet2. This works fine as a group at a time when requested. Once the data has been sent to Sheet2 it needs to sort by LENGTH + JOB IDs...

Hey I am using the below code to schedule runs of a macro. But I am worried that if there is some interruption to the scheduling, there will be a problematic delay before I pick up on it. So I'm wondering whether or not there is a way to check what and when macros have been scheduled if any...

Hi, I have 2 time formats in H:MM:SS AM/PM and I need to calculate in one cell the % adhered to the shift. If someone was scheduled to work 8-5 but actually worked 8:10-5:10, they got their 8 hours in but didn’t work it within the shift. The logic is Adherence = minutes within Aherence /...

Trying to figure out the best way to compare some dates and copy information associated with them. sheet1 is a schedule with dates for the entire year in Row 2, and names of employees in column A. Then filled in with various Letters depending on if the employee is scheduled to work, on...

I have 2 sets of date/time data I need to compare. Scheduled date/time Worked date/time Both the scheduled and worked data can have multiple entries throughout the day. How can I compare these two data sets?

Hi, I've been reading through threads for days and need help with a couple of formulas. I'm creating a scheduling spreadsheet for my office. I want it to calculate total hours scheduled for the office per day, and also total the employees total hours scheduled for the week, minus a 30 minute...

I run a macro that returns a table similar to below. These are change control tickets that need to be approved by 4 managers (APPDev, Help Desk, etc). From this table I would like to run a macro sending a single email to each manager listing the specific ticket number(s) that need to be...

Trying to take a report that is copied from another program into excel and remove the unneeded data and format it into a usable format. Code Currently using to remove Dates: If Cell Like "Tuesday*" Or Cell Like "Monday*" Like Cell = "Wednesday*" Then Cell.EntireRow.Delete End If It...

I have transformed my data as far as I can get and probably as inefficiently as possible but I am so close to what I want. In column 1 (Address) I have a list of all address' in column 2 (Activity) I have a list of all activities that happened at that address and column 3 (Count.1) I just added...

I am trying to write a code to send Outlook meeting invites based on what I have in a spread sheet. I am missing several key points in the code so decided to see if anyone out there can develop one that works better than the mess I created. Below is the type of spread sheet I will be using...