duration

  1. 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...
  2. 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...
  3. B

    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...
  4. 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...
  5. 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...
  6. 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...
  7. 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"...
  8. 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.
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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.
  16. M

    Time Calculation Formula

    Hi all, I have a column with the start time and a column with a minute duration. Can you help me put that into a formula on the next column that calculate the "end time"? Ex: <tbody> <tbody> Start time Duration by Minutes End Time 9:00 am 60 ? 11:00 am 120 ? </tbody> </tbody>...
  17. K

    Time Duration Issue

    I have a time duration issue once PM runs into AM. I will give an example of a working process (AM to PM) and one that doesn't work (PM to AM) Working Example: A1: Has 11:50 B1: Has 12:00 C1 Formula: =B1-A1 (this will equal 00:10 or 10 mins has gone by) Non-Working: A1: Has 23:50 B1: Has...
  18. S

    Pivot table and divide one calculated column by another column

    <style></style>I have one column that counts all the document names on a certain date and sums the values on that day. I am wanting to add a column that will divide the Duration by the sum of the Doc Names on that day. I cannot get the calculated field to do the correct calculation. I am...
  19. A

    Displaying A Duration in Time on a graph with general number formatted axis

    Hi, I'm looking for some help please. I need to find a way of including a value that is being displayed as a duration (e.g. 12:32 as mm:ss) but is inserted into excel using the decimal number system (as it allows me to add different times together). Generally these values that I am working...
  20. X

    Calculate service Year up to december

    Dear All, I have one trouble here. i have the following sample table with employees and thier hired dates. i want to calculate thier service years until december 31 2018 only. i want a general formula to calculate thier duration date. i tried deducting but kept getting negative months. i used...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top