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

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