I'm struggling with formula, which will count the number of operations "name" did simultaneously, even partially.
I'd like to have a 1 or 0 information in new column (1 = the time interval exist, even partially, anywhere else).
Data looks like this:
Hi, please i have three columns
Data is arranged as follows
Column A has 1440 arrival times to represent 1440 minutes in...
I have a spread sheet that lists the date and time of an event in the separate cell (mm/dd/yy h:mm). I need to find a way to count the simultaneous calls. Then it will output the maximum number of simultaneous calls based from given data regardless of number of row .
So for this example I...
Hi. I'm working with times. My data is all in 1 column A between A2:310 .
and am looking for outputs like this in the current empty cells between F9 thru H13:
Most frequent 60min period
Most frequent 30min period
I have a workbook with 2 sheets.
Day of the week
A table with all days of the week like this, with starting time of 0:00 to 23:00 in 1 hour increments( 1:00, 2:00, 3:00, etc..)...
Please, can any of you help with following problem that I have.
Problem goes like this:
We have a person who work in 24/7 support. One person work passive 24 hour, but it 24 hours are divided in to next shifts: normal 06-18, over hours 18-22, night hours 22-06.
So if we have...
I am new here although I have used it the forum as a guest a few times.
I have a problem and am not sure it is possible but if I am just not good enough.
On sheet 1 I have data in chronological order wit start and end date and time.
On sheet 2 I have other information by date and...