duration

Hi All, I need some help from all of you geniuses. I'd like to utilize a macro to delete rows in a spreadsheet based on a repeating set of formats. In the table below, the macro would need to start deleting at the first empty row (2) and finish with deleting the last row "Date/Time...

I am trying to create a Duration Curve, ie, a Scatter Graph consisting of hundreds if not thousands of data points plotted against sequential days (operating time). I need to be able to determine the value at 10% of the operating time (which may not be an integer) and draw a horizontal line...

Hi, I'm building a shift schedule for a restaurant. I want to have one cell with start time, one cell with end time, and one cell with duration. However, I want the duration to automatically subtract a 30-minute unpaid meal-period. I found an old thread with the formula below. It works...

Hi All, I have a call costs spreadsheet that shows me call cost and call duration. How can I work out the cost per min of that call? I have duration in column G and cost in Column H Duration shown as xx:xx:xx Cost shown as £xx.xx Thanks all.

Hello, I am trying to set up a formula in a workbook to firstly highlight a range of cells between two given dates. Secondly I am trying to populate these cells based on start and finish dates and the quantity of resource for a given item. Duration Column J =((H49-G49)/5)+0.2 (Where 0.2 is 1...

With two sheets, a Feeder sheet and a Database, I have two columns of data I would like matched. On the Feeder, all data is in rows: VALUE 1 -Location Time Cost Duration VALUE 2 -Location Time Cost Duration VALUE 3 -Location Time Cost Duration VALUE 4 -Location Time Cost Duration On Database...

It's possibly my search-fu is failing me here, or more likely I simply don't understand the answers I've found. I'm working on a project (due to some backend db errors that will eventually be resolved) that requires me to tabulate the duration of certain phone states. Unfortunately, the...

Hi all Hopefully I have posted this in the correct forum. I am trying to create a report that shows who is off today. I have three fields that show the date_from the date_to and the Duration (in days) The issue I am having is where someone has taken the full week off for example 12/02/2018...

I'd like to create a 'pseudo' gantt chart of sorts My Project data is on Columns A:U, TimelineDates start in Column V, Column A is the Project number and is always a number, never blank or NULL, There are 2 header lines, so the Project data starts in row A3...

I have rows/columns of times that looks like this: <tbody> Date Scheduled Appt Duration Actual Appt Duration AQR Appt Duration 12/1/17 6:00 4:37 5:03 12/4/17 0:00 0:00 0:00 12/5/17 6:00 5:02 7:10 12/6/17 5:30 2:14 2:34 12/7/17 6:00 4:00 4:46 12/8/17 0:00 0:00 0:00 12/11/17 6:00...

I got data as mentioned below in excel. All the activities are split in two different periods. For each such period I have to create a shape and place it according to its date and duration along the same row. e.g. in the below mentioned table for activity A, I will create two rectangular shapes...

I have a column with 56 rows. I want to insert duration in [h]:mm format without having to type colon. For that I formatted input cells using 0\:00 to get a return at row 57. The problem is, while adding up those duration I am getting erroneous results. e.g. 0:30 and 0:40 are added up as 0:70...

Hi, This is a simplified version of what I am trying to do: ** Spreadsheet being amended ** You can see that this is a time recording spreadsheet for visits to clients. To summarise, on day 1 the technician visits a client, selects the client name from a dynamic drop down list, enter the...

Hello, I have a pivot table that pulls data from time card records for projects. Each project has several time card entries and I want to find the duration of a project based on the first time card entry (earliest date) and the last time card entry (last date) for each project. I have a pivot...

Hello I am trying to create a gantt chart in excel with stacked bar chart It works fine for tasks with duration greater than zero, but for tasks with zero duration, nothing appears on chart as it is stacked bar diagram so i try to draw milestone tasks with scatter chart seperately which works...

Hello All, the negative duration in this table isn't showing in the chart. Date range is at the top, task name is vertical axis Sheet1 <tbody>#cacaca[/URL] "] B C D E #cacaca[/URL] , align: center"]5 Task Name Start End Duration (days) #cacaca[/URL] , align: center"]6...

Hi, I have a created a pivot table that shows the duration of run times. I am doing an average on the duration but want to remove the maximum value from the average as there are valid reasons for the run time to extremely longer than the remaining duration run times. How do I eliminate the max...

Hi there, I am looking for some help regarding identifying differences between a recorded amount of hours and the recorded duration (Start/end Time). In the following table Duration is calculated using "=B2-A2+(A2>L2). Row 1 would not need highlighting as duration is less than 60 minutes over...

hi guys, Need your help i have you help with a formula i need to populate a calendar according to a table that i have. at the moment i was able to do it for the time using the below formula...

Hi, Could you please help me with the following task: have a long list of activities and their start and end time. What I need is to split the duration of each activity by half an hour intervals as my example below. The blue intervals show beginning of each interval, for example interval...