Results 1 to 11 of 11

Categorize time ranges and calculate events within the time period

Threaded View

yklanka Categorize time ranges and... 08-07-2019, 06:49 AM
avk Re: Categorize time ranges... 08-07-2019, 07:10 AM
yklanka Re: Categorize time ranges... 08-08-2019, 12:28 AM
kvsrinivasamurthy Re: Categorize time ranges... 08-08-2019, 03:00 AM
yklanka Re: Categorize time ranges... 08-08-2019, 03:45 AM
avk Re: Categorize time ranges... 08-08-2019, 03:30 AM
AliGW Re: Categorize time ranges... 08-08-2019, 03:54 AM
yklanka Re: Categorize time ranges... 08-08-2019, 05:07 AM
kvsrinivasamurthy Re: Categorize time ranges... 08-08-2019, 10:06 AM
yklanka Re: Categorize time ranges... 08-08-2019, 11:13 PM
kvsrinivasamurthy Re: Categorize time ranges... 08-09-2019, 10:16 AM
  1. #1
    Registered User
    Join Date
    01-21-2017
    Location
    SRI LANKA
    MS-Off Ver
    2013
    Posts
    19

    Categorize time ranges and calculate events within the time period

    Dears


    I have a list of events (discharging / loading ) with a driver ID per particular event. each event has a date and time . My requirement is to categorize each time in to the time range ( if the date ,time is 07-Jul-19 10:39:22 then time range is 07-jul-19 10:00 - 11:00 ) and within the purticular time range how many events occurred by each driver ID. Appreciate your help. I have attached sample report .

    regards
    Yklanka
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula to calculate time between events
    By jeff0181 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-15-2018, 12:53 PM
  2. [SOLVED] Formula/method to sort by specific time period within date+time ranges in cell
    By mikeskins84 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-13-2018, 01:12 PM
  3. [SOLVED] Calculate the portion of a planned number during a period, based on another time period
    By BryGuy81 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-19-2017, 01:29 PM
  4. Replies: 12
    Last Post: 12-12-2012, 01:55 AM
  5. [SOLVED] Complicated:Calculate time period based on no. of units sold + fluctuations within period
    By omaha.crab in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-06-2012, 03:04 AM
  6. Replies: 2
    Last Post: 04-27-2011, 08:21 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1