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

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top