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

    Best Approach to create a column to display the comparison between current lap time and previous lap time?

    Hello guys, I have been trying for a few days to come up with the best approach to creating a column that will follow these rules, as yet without success: - It will read in a previously calculated cell *let us call it F41 for later reference* that has worked out the previous best lap time...
  3. L

    Google Sheets : How can I display duration of time with a "+" or "-" prefix?

    In Google Sheets I have a column that checks another two column's and calculates the difference. I already have it conditionally formatting to be green or red depending on the difference being less than or equal to 0, and greater than 0 respectively, but I specifically want to have it display...
  4. E

    Calculate remaining time

    I'm looking for either a formula or VBA that can actively run and calculate something for me. Here's the scenario: I have a total number of items to be completed in D319:E319 I have a total number of items that have been completed in D326:E326 I have a total number of items that are remaining...
  5. C

    Calculating duration sum hh:mm:ss

    I am trying to get a sum of time spent on the phone for agents. The format the duration is in is hh:mm:ss when I format the column and do =C2+C3 I get the correct output. When I do =SUM(C2:C55) the sum is 00:00:00. I've tried a few different ways to format and calculate the sum without luck...
  6. A

    How to check if a 2 specific time falls in between 2 times (Shifts) in Excel?

    1.I want to find out if an event with start time and end time falls "inside" or "Outside" working shifts for associates. 2.Segregate and calculate the production duration that falls within shift hours or outside shift hours. (The Shift timings are 5pm to 2am which would be the next day so that...
  7. F

    SUM IF Duration Is Between Certain Values

    Hi All! Could you please kindly advise as to how to sum duration values that fall between certain ranges? My custom format is set to [h]:mm and cannot be changed. Let me illustrate what I'm trying to do with an example. Columns A & B usually contain 9:00 & 17:30 respectively, however, at...
  8. BradleyS

    Sum duration values only if -3

    The table below shows an ID reference and each -3 (shown in red in my example only) is an accumulative count of the duration and needs to be added to the value above it. So if the ID is NOT - 3 it will be just be the adjacent duration value. However, if the ID is -3 it now has to be added to...
  9. masud8956

    Listing holidays separately and finding values in aggregate

    Hello experts! I don't know if it is too much to ask. I have a situation like the following: A2:A10 shows the timeline of a project. C2:C10 lists all working days between A2 and A10 excluding weekends (marked in red)and public holidays. C2=A2 but for C3 I have used...
  10. M

    Calculating Hours Worked and breaks taken

    Hello I thought I already posted this question but couldn’t find it anyways here I go I am working on a weekly staffing schedule and it has the follow info type C13 = start time ( 8:30 Am) D13=End-time (5:00 PM) E13 =Hours worked ( subtracting breaks with the following rules ) Works < 6...
  11. N

    Convert duration in text to HH:MM:SS format in excel

    I have an extract of data where the duration for an activity is listed as ## hour ## Minutes ## Seconds ex. 1 hour 22 minutes 29 seconds. Is there a way to convert this a time format so I can perform date math between two activities? Not all entries have hour, minutes and seconds. There are...
  12. S

    Another Time comparison problem

    So I have thousands of rows of data every day. In column F I have an event code and in column G I have the duration of that event. I need to know if "Event B" occurs within 20 minutes of "Event A". If F2 is "Event A" and G2 is 0:09:23 and F3 is "Event X" and G3 is 0:00:03 and F4 is "Event Y"...
  13. M

    Time Duration Between Two Dates and Times

    Hi, What formula would i use in D2 to get the correct days, hours and minutes duration between cells A2 and A3? A2 01/09/2019 19:07:30 PM D2 Formula to state 1 Day 11 Hours and 18 Minutes A3 02/09/2019 16:10:50 PM Thanks.
  14. S

    Yuck. Time in increments problem

    I have thousands or rows of data that include a start time and a duration. Something like this: A2 = Bob B2 = 8/15/2019 6:25:19 AM C2 = 12:38:13 AM (This appears on the screen as 0:38:13, the actual duration, and has a format of h:mm:ss) To that raw data, a formula in Column D takes the time...
  15. H

    Scheduling in Excel

    I need to create a gantt chart that will draw horizontal bars when I enter start and finish dates. The user would enter the item description, start date, and duration (in work days). Questions: - To get the finish date...I add the duration to the start date. How do I format the resulting...
  16. T

    Vba or Fomulas to give me 4 dates from a start date and duration

    Hi Everyone, Hoping someone can help with this, I would like to input a start date and durration and get 4 dates equal weeks apart from that info. So for example D2= Start Date, (I input 01/July/2019) D3= Duration in weeks (I Input 4 weeks) So I would get the following dates in range...
  17. R

    Block Schedule Chart Question

    Hello! I am trying to create a chart to represent block schedules by date. So far I set up my table and chart as you can see in the image in link ( https://photos.app.goo.gl/KKYhpmq6LVXaVtAP7 ). I am stuck with the following: If a date has more than one block (overlapping or not), can you...
  18. D

    how to create stacked bar for schedule/utilization

    Hi community, I need help creating the chart that shows how much time of the day a room has been used/been idle. Sort of look like a bar code. How do i create that? I have data of the time the procedure starts and its duration. <colgroup><col><col span="2"></colgroup><tbody> ID Start time...
  19. 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...
  20. P

    Hrs & Duration

    Trying to capture time, elapsed time, duration however you want to look at it. I want to be able to enter it to the nearest 1/4hr 4 hrs 00 min 4 hrs 15 min 4 hrs 30 min 4 hrs 45 min I'm not able to get this to work correctly.

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 MrExcel.com.
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 "mrexcel.com".
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