time ranges

  1. C

    count of time ranges in other time ranges

    Hi guys, 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: <tbody> name start end Mark...
  2. A

    Count total occurrence of time in a series of time ranges: Urgent Help Please?

    Hi, please i have three columns Data is arranged as follows Arrival Time Start Finish Count 13:23 14:24 19:50 13:23 14:24 19:50 13:24 13:05 17:20 13:25 12:12 22:22 : : : : 13:22 Column A has 1440 arrival times to represent 1440 minutes in...
  3. A

    Time Range Count

    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...
  4. T

    Most frequent time ranges or periods

    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: <tbody> Mode1 Mode2 Mode3 Most frequent 60min period (F9) Most frequent 30min period Most frequent...
  5. M

    VLOOKUP - Match Day and Time To return value from table

    Hi all! I have a workbook with 2 sheets. Sheet1 has: Day of the week Created time Number Sheet2 has: 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..)...
  6. G

    Calculating Start/End time between nigh shifts 24h

    Hello everyone, 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...
  7. D

    Vlookup within a time range

    Hi, 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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top