1. K

    Splitting activity duration by hour intervals

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

    Dynamic Reporting Calendar in Excel

    <b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /><col /><col /><col /><col...
  3. D

    What would be the best way to do this?

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

    Excel formula to add a minimum amount and add an extra hour

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

    Assigning work to people by day

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

    Help Countinting the number of sheets that have a value in a cell

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

    Activity Log - Excel

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

    Advanced Filter

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

    Excel formula to 'append' information together?

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

    Graph Activity by time of day

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

    Macro for Running a Series of Formulas for Multiple Categories

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

    VBA: fill cell with colors in another workbook

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

    List of time data using start and end times and presenting duration as an hourly table

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

    If time matches list of time within 5 minutes

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

    IF Statement to return Value

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

    "What If" slicer in a pivot table with actuals How?

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

    Please Help me with VBA on this large file

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

    index match, multiple columns/array with date, strings and blank cells

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

    How to update all Cell References Each month automatically rather than Manually

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

    Help with DATEDIF function dependent on if today's date appears in last row of column

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

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back