# time analysis

1. ### Time Value Distribution Automated?

Hi all, I am new to this so bare with me. Below is the current solution to my predicament, done manually. I would like to automate the distribution column. For this, the numerator is the TVU column, and the denominator is determined via the COUNTIF() function. The issue is that I cannot get...
2. ### Counting time from 2 cells if it is between a range

Hi, i'm a newbie in need of urgent help. I have a data set that records meeting occurrences. The start time and end time of the meeting are in a cell each (Rows I and J in the attached image). I am trying to count meeting occurrences looking at half hour intervals. For example if a meeting...
3. ### Counting a Time Range with COUNTIFS or SUMIFS

Good Morning I have an issue. I've been trying to create a formula to count the number of instances a particular time range appears in a column on a spreadsheet. Column C contains manually entered times followed by AM or PM. One problem I've run into that may or may not be effecting the...
4. ### Time issues

Hello I have a question I'm having problems finding a solution for. I have a time sheet which someone would complete as 07:00 in, 12:00 out for lunch, 13:00 Back from Lunch, 17:00 finish. What Im trying to do is to break down what the person has put in so it shows at what points during the day...
5. ### Sumifs/MAX formula Fix

Hello, In the following example below I am trying to use a SUMIFS/MAX formula to get the total sum of a event minus the allowed amount of time for a event. When i try to use the formula below i get a sum of 0:00:00 instead of the actual value. Should i use a different formula completely or does...
6. ### Time formula with conditions

Hi, I have two columns, one with a date and time (column A) and one with a status (column B). I want a third column(Column C) to say if the date and time in column A is less than today's date and the status in column B is not equal to 'COMPLETED' then move the date to today's date at 07:00:00...
7. ### Calculating incorret time recording

<tbody> Name Org Day Start End Minutes Incorrect Person 1 A Monday 5:05 pm 6:00 pm 0:55 0:25 Person 2 B Tuesday 5:05 pm 5:15 pm 0:10 0:10 Person 3 C Saturday 6:15 am 2:50 pm 8:35 0:00 </tbody> Hello all, Hoping someone can provide some assistance with...
8. ### Calculating variance, sum, average for range of rows during a specific time interval???

Hello all, I have a huge csv file with a few hundred thousand rows. I would like to perform statistical calculations on it and also obtain the first row value, for each time interval. Example for every 300seconds, I would like to calculate the variance of the total number of rows within the...
9. ### Help!!!

I need a formula that count how many Decembers in a range: eg.: start 08/18/2010 end 05/07/2015 = 5 start 08/18/2010 end 11/12/2010 = 0 start 08/18/2010 end 09/18/2015 = 5 Thanks
10. ### Time Format: Minutes showing up as Hours

Type: Excel Question Sub Type: Time Format Issue Description: I am extracting data from this tool, and I am getting this error, where Minutes are Showing up as Hours. They are not being converted. They are literally being moved to hours. Example: Value - 0:10:00 = 10 Minutes It is showing as...
11. ### Background color is not cooperating with my conditional formatting

So I am trying to create a log for run times for some furnaces. What I am trying to show is that the furnaces were not ran past/before a certain amount of minutes, I wanted the background to fill green when the time is between the minimum and maximum time allotment, and turn red when it is not...
12. ### Time in each hourly interval

I have a start time and end time in Col A & Vol B. Then i have 24 hourly intervals in next 24 columns. What I need is the time spent in each hourly interval e.g. Start Time: 3:20 am End time: 5:10 pm Interval: 00:00 to 01:00 00 01:00 to 02:00 00 02:00 to 03:00 00 03:00 to...
13. ### Multiple start and stop times (with overlap) on dates

I am trying to show the multiple jobs happening on given dates with their start and stop times represented by a bar. I wish to have time (00:00-23:00) on the vertical axis with dates along the horizontal axis. Each date would have multiple "jobs" occurring that day with potential for overlap. It...
14. ### VLOOKUP Help - Combining several cells (example included)

Hey guys! I'm doing some time analysis and I was hoping someone could offer some help. Basically, I've broken down my days into several different categories and I'd like to summarize the total of each category for each day. Kind of hard to explain, see my example for clarification :) Thank you...
15. ### Calculate difference between two times

Hello. I have a text string that represents a date and time that an employee has signed in. It is a long text string <tbody> (20170102205400) which represents 8:54:00PM 01/02/2017 I then have another time, punch out time: <tbody> (20170103070200) I tried using the TIMEVALUE formula, and that...
16. ### Time help required

I have a “time taken” to work sheet set up but want to add an additional feature. Its set up to log in and log out and works out the time taken to process. I want to add a feature that once logged in, if not logged out in under 1 hour either a cell or the row turns red as a warning. When...
17. ### Lookup the time from a row data

Happy New Year to everybody, I am trying to make a time-sheet format from a row attendance data. Row data will look like as below: <tbody> ID # Date Time Type 100 1/1/2017 07:00 AM IN 100 1/1/2017 05:00 PM Out 100 2/1/2017 08:00 AM IN 100 2/1/2017 01:00 PM Out 100 3/1/2017 10:00 PM In...
18. ### Referencing time within two times with an additional Text Criteria

In simple terms, I am trying to do this: If TEXT in Sheet3!A2 equal TEXT in Sheet2!C:C and if TIME in Sheet3!D2 is within TIMES in Sheet2!I:I and Sheet2!J:J return TEXT in Sheet2!O:O I was able to build a formula that returns the TEXT in Sheet2!O:O however the time has to be exact and I am only...
19. ### Identify timestamps that occur within 5 minutes of an event.

I searched the forum for similar questions but didn't see anything. Here's the question: We're running TV commercials and want to see leads that came into our website within 5 minutes after a commercial airs. We have a list of times when the commercials ran and a list of times we received...
20. ### SUM function does not work correctly for time formatted data in table & pivot table

Using Excel 2016 for Win. I have time data in a column like 00:00:28 - if I use the SUM function =SUM(E9:E14) I get 00:00 in the calculated field. If I do the operation "long-hand" =E9+E10+E11+E12+E13+E14 I get the correct value. I did not generate the data, so I thought some of it must be...