time analysis

Hi, I am trying to sum data in a column which is formatted as [HH]:MM; as the number of hours are in thousands now I thought it'll be helpful to give the user the opportunity to see data in days to better quantify the data point. To do so I convert the data from [HH]:MM to DD:HH however now...

<colgroup><col><col span="6"><col><col></colgroup><tbody> M T W H F S U starting date ending date 1 0 0 0 0 0 0 29/4/2013 7/10/2013 </tbody> hey guys i have the previous data set which represent a flight that starts 29/4/2013 and ends 7/10/2013 and is going to take place every monday i...

Hello, I am working on a project where I need to split hours between departments. So for example if a shift was done from 7am to 7pm it would be coded to the department in Department 1 (column A). If it was worked from 7pm to 7am it would be coded to the department in Department 2 (column B)...

I am feeling rather lost - I spent from 9am yesterday morning to 5am this morning trying to solve this problem to no avail. I have a report due tomorrow at 12pm and need to get this finalized on a tight timeline. About to lose it haha :eeek:! For the sheet below I have 7 cases that I need to...

Hi friends, I have created a sheet, where I have the following: Module/Project Task Time taken by developer 1 Time taken by developer 2 Time taken by developer 3 Time taken by developer 4 Time taken by developer 5 Developers are segregated by offices, so there are 2 types right now, can be...

All, I need some help creating a dynamic formula that calculates a percentage based on when a benefit is supposed to begin. For example, let's say we receive the following data about an "Awesome Benefit" that we will start realizing in Q3 2015. 100% will be realized by end of 2017. <tbody>...

Here's the simplified situation <tbody> A B C D 1 Time start Time End Duration 2 08:40 AM 08:55 AM 00:15 =COUNTIF(C2:C3,"=0:15") 3 04:20 PM 04:35 PM 00:15 </tbody> PROBLEM: The countif returns only "1", this kinda puzzles me I've tried applying *1440 to convert C2 and C3 into...

The time between Each Arrival (X) and Departure (Y) is dwell time. The dwell time needs to be checked against a list of Outage Start (A) and Outage End (B) times. The dwell time can be excused in portion or entierly if there is an outage time for the same period. There can be multiple seperate...

I am trying to create an SLA (service level agreement) report. I have data that supports a date/time that something was requested and a date/time of completion all associated with 1 time zone. I need to be able to calculate the number of minutes between request to completion. Then take that...

Good morning everyone, I am back to this amazing forum that has given a LOT to excel community and thank you everyone for that :) So I have this spreadsheet where it is basically call center data so in one of the column it shows time of inbound call as example (21:12:05) and other columns...