activity

Hi, i hope someone can help me. I try something similar as already described here: Splitting activity duration by half an hour intervals I too have a long list of activities and their start and end times. What I need is to split the duration of each activity into hourly intervals. At "Normal"...

Book1ABCDEFG1Input Data2DateBDFrequencyActivity3Friday, November 1, 20191WeeklyMgmt Report4Monday, November 4, 20194WeeklyRevenue Report5Monday, November 4, 20194WeeklyTrade Report6Tuesday, November 5, 20195Bi WeeklyForecasting7Tuesday, November 5, 20195Bi WeeklyIncome Statement8Wednesday...

I am making a spreadsheet that allows you to enter an activity, press a button, then it stores the activity. A list of activities are compiled over time and there is another button that selects a random activity from the list. You can't use variables for this as they only last until the...

I have a spreadsheet with data entered into cells A5:E11 in a matrix. This is a named range with the name Service_Types. Along the top, starting at B5 I have Mon-Fri, Sat, Sun and Public Holiday. In column A, starting at A6, I have a list of activities. The cells contain hourly cost of certain...

Good afternoon, I download a spreadsheet once a month that contains workorders for a given department. The workorders are divided up by responsibility and by the activity code. We then assign the correct employee and shift to the workorder (manually right now). In Power query I have the table...

Hello, I have a workbook with 25 sheets (tabs), each representing a different project with data reporting the number of people reached by that project for a range of different activities. Not all projects did all activities. I have a consolidated sheet in which I need to count the total number...

Hi Everyone, I have an excel contains value and embed objects. I Want since open, all activity should be track in excel (Edit, Add, add/delete embed docs etc) log should be password protected on excel. is it ppossible? let me know for further questions

Dear all, i have a table as follows Activity Code Date 0101 3/14/2019 0201 1/13/2019 0203 3/1/2019 0203 1-1-2019 0203 1-4-2018 0340 2/3/2018 0344 1/1/2017...

Hi all - I am attempting to use Excel to find information from one table and assign it to other tables....which is normally easy....but there is a conundrum I have run across. For example: <tbody> I currently have this information: Standard Section Activity 200.01-14 627 200.15-17...

Hi all, I've managed to stump myself on what should be a fairly simple task. I have a data file with activity by time for employees. Each action has a time next to it. I'd like to create a chart that visualizes the breaks between actions so that one can see for example that someone took a...

Hello, I have a report that breaks down various scores for a number of different activities by employee. I want to run some statistical analysis per activity by employee to look for and delete outliers. I need the code to first run the average for each activity, then STDEV.P, and then finally...

Hello there, In workbook1 I have the following: ...................Name 1.......Name 2 2019-04-16 2019-04-17 2019-04-18 2019-04-19 2019-04-20 2019-04-21 2019-04-22 In workbook2, I have data as such: Name 1...........Activity 1.........Activity 2 Start...

Hi all, I have a list of activities that include the start and end time - I need to sum the duration of these activities into a table with hourly intervals. It would be easy enough if all the activity was only an hour in duration :laugh:, however there are activities that are an hour and 30...

Hi All, I currently have the below formula: =IF(AND(R2="c",MATCH(D2,'Activity Report'!$A$3:$A$8),MATCH(B2,'Activity Report'!$C$3:$C$8)),"Confirmed","False") The Cell B2 and the column of C in the Activity Report are time and dates, formatted as (dd/mm/yyyy hh:mm:ss). Effectively, when I am...

My excel workbook was built by a previous employee and I am not having any luck updating the excel formula to return the value needed. The formula is used to scan bank transaction descriptions and identify store activity. The formula below currently determines if the activity is cash or...

I have a simple pivot table that categorizes checkingaccount activity like this: Paycheck 100 100% Grocery -10 10% Rent -5 .05% Gas -5 .05% Etc… Total 80 80% A power...

Hi All I have 2 sheets with almost 300k rows of data.. The columns are from A to Q the dates, agent name and start times and times are sorted to sort each agent schedule that day I need to have a macro that loops through every day and checks to see if an agent had any activity that say...

Hi, I have a problem regarding a structure for project management and specifically deadlines. On the rows I have different customers/projects which each have columns with different activities, e.g.: <tbody> Project/Customer Deadline activity 1 Deadline activity 2 Deadline activity 3...

Good morning, I have Excel 2010 and I should have asked this question years ago, but better late than never I suppose. I am just hoping there is a more efficient way to do what I have been doing for years. I report every month some of my staffs activity from the previous month. I have on the...

Hi I have the following formula in Cell A10: =(DATEDIF(TODAY(),DATE(YEAR(TODAY()),12,31),"d"))+1 This calculates the number of potential activity days left in the year. However, as it's only based on the calendar, the result is incorrect when the current day's activity has taken place. What...