categorize times

  1. F

    Help with Categorize Rows based on multiple conditions , VBA/ Excel Formula

    I have uploaded what my current sheet look like and what is my goal. -Sheets are categorized by Road ID and are ordered increasingly. - Every row is identified by Road ID, Start meter and End Meter - Each row indicates data (Road Id, Start,End,Lane,Speed,Event 1 and more which I trimmed at this...
  2. J

    Sorting times by time ranges

    I have a spreadsheet where cell values of times range from 00:01 (minute) to over 04:00 (four hours). What I want to do is categorize those times into ranges, i.e., 1 minute or less, 2-5 minutes, 6-10 minutes, 11-20 minutes, etc. and reflect that information on the same line as the remaining...

Some videos you may like

This Week's Hot Topics